Senior Data Engineer

3 weeks ago

Chesterfield, Missouri, United States Software Design Partners Full time

About Us

At 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 their work, 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.

Responsibilities

  • Continuously learn and leverage the latest data management tools and practices.
  • Architect, design, develop, and implement solutions with databases, database systems, integration processes, and analytics.
  • Design and implement data warehouse/business intelligence solutions using Azure Fabric.
  • Work with pipelines, data lakes, SQL Serverless, SQL Dedicated Pools, etc., to design and implement data warehouse/business intelligence solutions using Azure Synapse.
  • 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 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...

  • 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 Software Engineer

    3 weeks ago

    Chesterfield, Missouri, United States The Timberline Group Company Full time

    We are seeking a highly skilled Senior Software Engineer to join our team at The Timberline Group Company. As a key member of our software development team, you will be responsible for designing and implementing new systems and features, as well as modifying and maintaining existing systems to support new business needs and/or technology changes.The ideal...

  • Data Engineer

    3 weeks ago

    Chesterfield, Missouri, United States Insitiform Technologies, LLC Full time

    Aegion Corporation and its family of companies shield and protect the world's infrastructure from degradation and corrosion with a variety of technologies and services.With operations in multiple countries across the world, a career at Aegion will provide challenging and innovative opportunities with a company that is a technology leader in their...

  • Senior Quality Manager

    4 weeks ago

    Chesterfield, Missouri, United States Aegion Full time

    Senior Quality ManagerInsituform Technologies, LLC, a subsidiary of Aegion Corporation, is a leading provider of cured-in-place pipe (CIPP) and other technologies and services for pipeline rehabilitation. The company seeks an experienced Senior Quality Manager to drive measurable results and behaviors that positively impact Aegion customers and investors.Key...

  • Risk Data Analyst

    4 weeks ago

    Chesterfield, Missouri, United States Inova Health System Full time

    Job SummaryWe are seeking a highly skilled Risk Data Analyst to join our team at Inova Health System. As a Risk Data Analyst, you will play a critical role in the production of key risk measures and analytics, including position reporting, VaR analysis and reporting, macroeconomic analysis, and liquidity analysis.Key Responsibilities:Work with Manager,...

  • Senior Software Engineer

    1 day ago

    Chesterfield, Missouri, United States The Timberline Group Company Full time

    About the RoleThe Timberline Group is seeking an experienced Senior Software Engineer to join our team. As a key member of our development team, you will be responsible for designing, implementing, and maintaining software systems that meet our business needs.Key ResponsibilitiesContribute to the ongoing execution of applications and services, aligning...

  • Senior LIDAR Analyst Position

    4 weeks ago

    Chesterfield, Missouri, United States Bowman Consulting Group, Ltd. Full time

    Job Summary: Bowman Consulting Group, Ltd. is seeking a highly skilled Senior LIDAR Analyst to join our team. As a Senior LIDAR Analyst, you will be responsible for the production of LIDAR data, including point cloud processing, classification, and reporting standards. You will also be involved in feature extraction and calibration to ensure products meet or...

  • Transmission Project Engineer

    4 weeks ago

    Chesterfield, Missouri, United States Electrical Consultants, Inc. Full time

    Job DescriptionElectrical Consultants, Inc. (ECI) is a leading power engineering consultant firm that provides engineering, system planning and studies, technical consultation, project management, surveying, environmental planning, commissioning/testing and construction services to electric utilities, energy developers and industrials throughout the U.S.We...

  • Project Engineer

    4 weeks ago

    Chesterfield, Missouri, United States Oscar Full time

    Job SummaryWe are seeking a highly skilled Project Engineer to join our team at Oscar Associates Limited. The successful candidate will be responsible for providing technical direction and management of medium and large-sized PV projects.Key ResponsibilitiesReview contracts and summarize system design requirementsProvide technical direction in the execution...

  • Senior Business Systems Analyst

    3 weeks ago

    Chesterfield, Missouri, United States Lorven Technologies Full time

    Job Summary Lorven Technologies is seeking a highly skilled Senior Business Systems Analyst to lead projects related to computerized document creation, workflows, interfaces, and storage for criminal and civil systems, including the CRIS project. The ideal candidate will have 6+ years of experience in business analysis and technical tasks such as project...

  • Senior Analytical Scientist

    3 weeks ago

    Chesterfield, Missouri, United States Integrated Resources Full time

    Job Title: Senior Analytical ScientistJob Summary: We are seeking a highly skilled Senior Analytical Scientist to join our team at Integrated Resources. As a key member of our vaccine project team, you will be responsible for co-authoring analytical method validation documents, reviewing source documentation, and ensuring the accuracy and completeness of...

  • Senior Building Automation Systems Engineer

    4 weeks ago

    Chesterfield, Missouri, United States VeregyLLC Full time

    Job Title: Controls EngineerVeregy LLC is seeking a highly skilled Controls Engineer to join our team. As a Controls Engineer, you will be responsible for designing, implementing, and optimizing building automation systems to reduce energy consumption and increase facility-wide energy efficiency.Key Responsibilities:Assist with and manage building automation...

  • Receptionist

    4 weeks ago

    Chesterfield, Missouri, United States Tutera Senior Living & Health Care Full time

    Job OverviewWe are seeking a highly motivated and detail-oriented Receptionist to join our team at Tutera Senior Living & Health Care. As a Receptionist, you will be responsible for providing exceptional customer service and administrative support to our facility personnel.Key ResponsibilitiesGreet all visitors and provide a warm and welcoming...

  • Senior Investment Analyst

    3 weeks ago

    Chesterfield, Missouri, United States RGA Reinsurance Company Full time

    Job DescriptionRGA Reinsurance Company is seeking a highly skilled Senior Investment Analyst to join our Investment Solutions team. As a key member of our team, you will be responsible for supporting portfolio managers in various quantitative and analytical functions for asset-intensive reinsurance transactions.Key Responsibilities:Design...