Senior Data Engineer

4 weeks ago

Chesterfield, United States Software Design Partners Full time

About Us 

Our people are our biggest asset. They support the core of our existence, and we take pride in their skills, proficiency, and achievements. This belief allows us to create the best working environment for our employees that provides a technically challenging and rewarding experience along with a healthy work-life balance.  


We look for professionals who are driven, motivated, passionate about their work and are willing to take initiatives to work towards achieving goals by team effort. We'll make sure you get valuable feedback, coaching, and knowledge from the people you work with and help you offer the same to others.  


The Role 

As a Senior Data Engineer you will be working alongside others on the Software Design Partners team in developing effective and high-quality data solutions that meet customer business objectives. This role will be responsible for architecting data solutions, designing and creating data models, transforming data using ETL tools, developing integrations, as well as working with our development and business intelligence teams. This role will also have customer-facing responsibilities including defining current state and future state data architectures, gathering and validating requirements, handling requests, providing updates, and troubleshooting issues. 


An ideal candidate will have a strong technical background, natural technical curiosity, the ability to learn as technology changes, and a desire to contribute wherever needed. 


Responsibilities

  • Continue to learn and leverage the latest data management tools and practices. 
  • Architect, design, develop and implement solutions with databases, database systems, integration processes and analytics. 
  • Azure Fabric to design and implement data warehouse/business intelligence solutions. 
  • Azure Synapse working with pipelines, data lakes, SQL Serverless, SQL Dedicated Pools, etc. to design and implement data warehouse/business intelligence solutions. 
  • Design, develop and maintain semantic models using SQL Server, SQL Server Analysis Services, Microsoft Fabric and other database systems. 
  • Analyze data, identify relationships, and relate data to business processes. 
  • Utilize ETL tools to move and transform data between systems. 
  • Troubleshoot, diagnose, repair, and document solutions and problems with databases, database systems, or integration processes. 
  • Effectively communicate orally and in writing in a clear and straightforward manner. 
  • Evaluate business processes, identify areas for improvement, and document requirements. 
  • Collaborate with external clients to gather requirements, handle requests, provide updates and troubleshoot issues. 
  • Work closely with business analysts, application architects, QA test engineers, project managers, and other teams.  
  • Work independently or in a team-based environment depending upon the project needs.  
  • Handle multiple projects and tasks, make decisions, solve problems, prioritize and organize effectively, and show initiative in a fast-paced environment. 
  • Follow established best practices for database and data warehouse architecture. 


Background and Qualifications

  • Bachelor’s degree or equivalent experience. 
  • 5+ years related experience or more. 
  • Experience in building data lake houses in Azure Synapse or Azure Fabric 
  • Experience in designing data models and knowledge of different ETL design and development methodologies (e.g. SSIS, Apache Kafka, Apache Spark, Talend). 
  • Experience with extracting data from relational databases as well as 3rd party software.  
  • Knowledge and experience using business intelligence tools such as Power BI or Tableau.  
  • Configuring databases and services, setting up service accounts. 
  • Development experience with SQL (Preferably TSQL). 
  • Strong analytic and problem-solving skills.  
  • Broad business-related knowledge.  
  • Experience in gathering and documenting business and functional requirements. 
  • Must be authorized to work in the US for any employer. 


Preferred skills, but not required: 

  • Understanding of Business Intelligence/Data Warehouse architecture and concepts. 
  • DAX or MDX experience. 
  • Building solutions in Microsoft Fabric. 
  • Experience using Python. 
  • Reporting experience using SSRS, Power BI or other similar tools. 
  • Open source DB background (e.g. PostgreSQL, MySQL). 
  • Cloud database experience with Amazon Web Services (AWS) or Google Cloud 


  • Senior Data Engineer

    2 months ago

    Chesterfield, United States Software Design Partners Full time

    About Us Our people are our biggest asset. They support the core of our existence, and we take pride in their skills, proficiency, and achievements. This belief allows us to create the best working environment for our employees that provides a technically challenging and rewarding experience along with a healthy work-life balance.  We look for...

  • Senior Data Engineer

    4 weeks ago

    chesterfield, United States Software Design Partners Full time

    About Us Our people are our biggest asset. They support the core of our existence, and we take pride in their skills, proficiency, and achievements. This belief allows us to create the best working environment for our employees that provides a technically challenging and rewarding experience along with a healthy work-life balance.  We look for...

  • Senior Data Engineer

    2 months ago

    chesterfield, United States Software Design Partners Full time

    About Us Our people are our biggest asset. They support the core of our existence, and we take pride in their skills, proficiency, and achievements. This belief allows us to create the best working environment for our employees that provides a technically challenging and rewarding experience along with a healthy work-life balance.  We look for...

  • Senior Data Engineer

    3 weeks ago

    Chesterfield, Missouri, United States Software Design Partners Full time

    About UsAt Software Design Partners, we believe that our people are our greatest asset. We take pride in their skills, proficiency, and achievements, creating a working environment that provides a technically challenging and rewarding experience along with a healthy work-life balance.We look for professionals who are driven, motivated, and passionate about...

  • Data Engineer

    2 weeks ago

    chesterfield, United States Prestige Staffing Full time

    WHAT YOU’LL DOAutomate data wrangling from a wide variety of sources (flat files, remote servers, databases, legacy systems, message queues, APIs and more)Identify opportunities to improve system and business process efficienciesCleanse/transform data in preparation for all levels of analytical useLeverage many technologies and methodologies as...

  • Data Engineer

    2 weeks ago

    chesterfield, United States Prestige Staffing Full time

    WHAT YOU’LL DOAutomate data wrangling from a wide variety of sources (flat files, remote servers, databases, legacy systems, message queues, APIs and more)Identify opportunities to improve system and business process efficienciesCleanse/transform data in preparation for all levels of analytical useLeverage many technologies and methodologies as...

  • Data Engineer

    2 weeks ago

    Chesterfield, United States Prestige Staffing Full time

    WHAT YOU’LL DOAutomate data wrangling from a wide variety of sources (flat files, remote servers, databases, legacy systems, message queues, APIs and more)Identify opportunities to improve system and business process efficienciesCleanse/transform data in preparation for all levels of analytical useLeverage many technologies and methodologies as...

  • Senior Data Architect

    2 weeks ago

    Chesterfield, United States Serigor Inc Full time

    Job Title: Senior Data ArchitectIn this key role, you will collaborate with our business partners to develop data mapping from one system to another. The ideal candidate will have a solid attention to detail, be able to manage tedious tasks, and be proficient with Azure Data Factory Pipelines and T-SQL stored procedures or SSIS packages.Responsibilities:•...

  • Senior Project Engineer

    3 weeks ago

    Chesterfield, Missouri, United States Oscar Full time

    Job SummaryAs a Senior Project Engineer at Oscar Associates Limited, you will be responsible for providing technical direction in the execution of technical scope of work on medium and large sized PV projects. You will manage electrical, civil, mechanical, and structural Engineer of Record scopes for assigned projects, and coordinate various engineering...

  • Data Maintenance Engineer

    3 weeks ago

    Chesterfield, United States Jones Lange Lasalle, Inc. Full time

    BI Tools Implementation: Utilize business intelligence tools to create and maintain dashboards and reports to track maintenance performance metrics and KPIs that provide insights into maintenance operations, enabling informed decision-making. CMMS Ma Maintenance Engineer, Industrial Engineer, Equipment Maintenance, Data, Engineer, Mechanical, Manufacturing,...

  • Senior Auditor

    4 weeks ago

    Chesterfield, Missouri, United States Mercy Full time

    Senior Auditor - Data AnalyticsWe are seeking a highly skilled Senior Auditor - Data Analytics to join our Internal Audit team. As a Senior Auditor, you will be responsible for leading aspects of audits, including planning and executing the audit, developing the risk matrix and audit program, and coordinating fieldwork with process owners.Key...

  • Senior Transportation Engineer

    4 weeks ago

    Chesterfield, Missouri, United States Olsson Full time

    Job Title: Senior Transportation EngineerWe are seeking a highly skilled Senior Transportation Engineer to join our dynamic and expanding Roadway team in the St. Louis area. As a key member of our team, you will play a pivotal role in shaping the success of our growth in the region.About the RoleIn this influential position, you will be responsible for...

  • Senior Water Resources Engineer

    3 weeks ago

    Chesterfield, Missouri, United States Olsson Full time

    Job Title: Senior Water Resources EngineerJob Summary:We are seeking a highly skilled Senior Water Resources Engineer to join our team. As a Senior Water Resources Engineer, you will provide high-level technical support and lead QA/QC activities within a team.Key Responsibilities:Provide high-level project design and review project documents to ensure design...

  • Healthcare MLOps Engineer

    4 weeks ago

    Chesterfield, Missouri, United States Mercy Full time

    Overview: Healthcare - Machine Learning Ops EngineerThe Machine Learning Operations (MLOps) Engineer works with a team of data scientists to design and develop machine learning frameworks that accelerate model development and productionalization. This position supports Mercy's efforts to deliver personalized, predictive, and proactive care.The MLOps Engineer...

  • Senior Industrial Estimator

    2 days ago

    Chesterfield, Missouri, United States Industrial Manufacturing Full time

    Job SummaryWe are seeking an experienced Senior Industrial Estimator to join our team at Industrial Manufacturing. As a key member of our operations team, you will play a crucial role in estimating costs for manufacturing projects.About the RoleThe Senior Industrial Estimator will be responsible for preparing comprehensive project estimates, collaborating...

  • Senior Water Resources Engineer

    4 weeks ago

    Chesterfield, Missouri, United States Olsson Full time

    Job SummaryWe are seeking a highly skilled Senior Engineer to join our Water Resources team at Olsson. As a key member of our team, you will provide technical leadership and expertise on complex projects, ensuring high-quality design and review of project documents.Your expertise will be invaluable in advising and directing staff on design approaches,...

  • Senior Business Intelligence Developer

    2 weeks ago

    chesterfield, United States nimble solutions Full time

    Description ***This is a hybrid position that will require a minimum of two days per week in our Chesterfield office***Why work at nimble? This is a great opportunity to join a well-established and market-leading brand serving a high growth end market while gaining valuable experience working closely with Executive leadership. As an organization, we are in...

  • Senior Business Intelligence Developer

    2 weeks ago

    Chesterfield, United States nimble solutions Full time

    Description ***This is a hybrid position that will require a minimum of two days per week in our Chesterfield office***Why work at nimble? This is a great opportunity to join a well-established and market-leading brand serving a high growth end market while gaining valuable experience working closely with Executive leadership. As an organization, we are in...

  • Senior Business Intelligence Developer

    7 days ago

    chesterfield, United States nimble solutions Full time

    Description***This is a hybrid position that will require a minimum of two days per week in our Chesterfield office*****This position is not eligible for relocation assistance***At this time we are unable to consider candidates currently on a work or student visa or those that will require sponsorship at a future date*Why work at nimble? This is a great...

  • Senior Business Intelligence Developer

    2 weeks ago

    chesterfield, United States nimble solutions Full time

    Description***This is a hybrid position that will require a minimum of two days per week in our Chesterfield office*****This position is not eligible for relocation assistance***At this time we are unable to consider candidates currently on a work or student visa or those that will require sponsorship at a future date*Why work at nimble? This is a great...