Data Engineer

Lexicon Services • Chesterfield, MO

3d

About The Position

The Data Engineer will be responsible for designing, building, and maintaining data pipelines and infrastructure to support data-driven decision-making across the firm. Your role will involve collaborating with data scientists and analysts to ensure seamless access to high-quality data, while optimizing data storage and processing for maximum efficiency. This role reports to the Data Science Manager as part of the Data Science team.

Requirements

• 3-5 years in data engineering or related experience.
• Experience with Microsoft Fabric, Power BI, Data Model design, Data warehouse concepts, and Strong T-SQL skills.
• Experience with Python/PySpark programming
• Ability to manage multiple tasks and projects simultaneously.
• Ability to analyze large amounts of data.
• Advanced skills in Microsoft Office Suite (Outlook, Excel, Word).
• Solid understanding of database management systems.

Nice To Haves

• Relevant certifications are a plus
• Microsoft Fabric Data Engineer certifications a plus.
• Knowledge of additional programming languages (e.g. R, PowerShell) is a plus
• Experience with No SQL data structure and APIs is a plus.
• Technical experience with Data Mining and Machine Learning techniques is a plus.

Responsibilities

• Develop algorithms to transform data into useful, actionable information.
• Identify and acquire new data sources and assemble complex datasets that align with business needs.
• Create and maintain data infrastructure for optimal extraction, transformation, and loading data from various data sources using Microsoft Fabric technologies and Medallion Architecture best practices.
• Identify, design, and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
• Implement processes and systems to monitor data quality, troubleshoot and resolve data related issues, and improve data reliability and quality.
• Collaborate within the Data Science team to improve data models that feed business intelligence tools, increase data accessibility, and foster data-driven decision making across the organization.
• Work with stakeholders including Executive Leadership, Application Development, Marketing, and Finance to evaluate business objectives, support data infrastructure needs, and assist with data-related technical issues.
• Ensure compliance with data governance and security policies.
• Maintain documentation for database and data pipeline infrastructure.
• On-call support rotation once per month.

Benefits

• Industry-Leading Health Coverage: Access to top-tier health, dental, and vision insurance plans, ensuring you and your family stay healthy and protected.
• Financial Security: Enjoy peace of mind with life insurance, as well as both short-term and long-term disability coverage.
• An Investment in Your Future: Our competitive 401(k) plan with company match, helps you plan ahead, with opportunities to build and grow your retirement savings.
• Flexible Spending Options: Take advantage of flexible spending accounts (FSA/HSA) to cover out-of-pocket medical, dental, and childcare expenses with pre-tax dollars.
• And So Much More: From wellness programs to additional perks, we go above and beyond to create a workplace that values and supports you every step of the way.

What This Job Offers

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