Senior Data Engineer- MSI

MSI, part of The Baldwin Group

1d • Remote

About The Position

The Senior Data Engineer designs and manages data systems, pipelines, and management tools. The role oversees junior data engineers, recommends and deploys data models, and leads projects involving data collection and storage systems. It designs, builds, documents, tests, and maintains critical pipelines that process large volumes of data from internal and external sources across different platforms. The engineer collaborates with architects, analysts, and stakeholders to define pipeline and automation requirements; performs ETL and ELT in accordance with enterprise data governance and security standards; and develops quality and governance processes to ensure data accuracy.

Requirements

• 5–7 years of relevant experience.
• Bachelor of Arts or Bachelor of Science degree in a relevant discipline.
• Experience with multiple development methodologies.
• Experience building large, complex data pipelines across different platforms, data sources, and data structures.
• Experience with relational databases such as SQL Server or Oracle, and SQL scripting.
• Experience with Power BI.
• Experience with cloud platforms such as AWS, Azure, or GCP and their ETL tools and techniques for sourcing, maintaining, and updating data, data warehousing, data cleansing, and transformation.
• Programming experience in Python, Spark, and similar languages.
• Advanced programming knowledge and experience with large-scale processing engines, and a deeper understanding of database security and compliance tools.
• Understanding of computer systems, integrations, databases, and data storage systems.
• Understanding of agile data engineering concepts and processes.
• Ability to document business processes and requirements and work with colleagues to create functional requirements.
• Ability to work with clients to translate business needs into technical solutions.
• Detail-oriented and proactive in preventing or mitigating issues.
• Excellent interpersonal and communication skills, including the ability to communicate effectively with teams across the organization.
• Proficiency in Microsoft Office Suite, including Word, Excel, PowerPoint, and Outlook.
• Ability to learn other appropriate programs or software systems used by the firm.

Responsibilities

• Collaborate with data architects, analysts, and stakeholders to identify and document requirements for data pipelines and process automation.
• Design, build, document, test, and maintain data pipelines using industry best practices.
• Perform ETL and ELT operations in accordance with enterprise data governance and security standards.
• Develop data quality and governance processes to ensure data accuracy and quality through inspection, validation, processing, and anomaly detection.
• Oversee and provide guidance, mentoring, and training to junior data engineers and peers.
• Recommend and deploy data models and lead projects involving data collection and storage systems.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior