Senior Data Engineer

Role Description

The Senior Data Engineer will design and build tools and processes that help clients derive meaningful insights from their data. They will help clients understand their data needs and how to use data to reach business goals. They will also provide mentoring to data engineers. They will work closely and collaboratively with our Data Architect and Business Solution Advisor to develop solutions that increase value and confidence in our clients' data environments.

• Designs and implements secure data integration solutions for operations and analytics, leveraging best practices to design and implement high-performing ETL/ELT solutions.
• Performs root cause analysis on data sets and processes to answer specific business questions and identify opportunities for improvement.
• Builds and maintains KPI dashboards to disseminate information to measure/track results and drive business decisions.
• Integrates reports, audits, and processes from various business systems.
• Advocates for data quality and increases awareness of data stewardship and data governance concepts among data producers and consumers.
• Assists with defining and maintaining business rules, policies, and governance for data.
• Collaborates with Data Architect on project goals and approach.
• Assists peers and data engineers as needed, to keep the team as productive and efficient as possible.
• Works with QA and development peers to review and test code changes.

Qualifications

• A minimum of eight years of progressive responsibility working as a Data Engineer or Data Integration Developer.
• Advanced SQL skills with experience working with Microsoft Fabric Lakehouse, Fabric Warehouse, Azure SQL Database, Azure Synapse Analytics, and large-scale structured and semi-structured datasets.
• Knowledge to leverage Artificial Intelligence and Machine Learning capabilities within Microsoft Fabric, Azure Machine Learning, Azure AI Services, and Python-based data science solutions.
• Referenceable work history developing interactive dashboards and data visualizations using Power BI, Fabric Real-Time Intelligence, and Power BI Service.
• Demonstrated capabilities designing, implementing, and supporting cloud-native data platforms utilizing Microsoft Fabric, Microsoft Azure, OneLake, Azure Data Lake Storage Gen2, and Azure data services.
• Strong background working with data integration and orchestration tools including Microsoft Fabric Data Factory, Azure Data Factory, Fabric Pipelines, and related ETL/ELT technologies.
• Experience designing and implementing enterprise data models, dimensional models, data warehouses, Lakehouse architecture, and semantic models within Microsoft Fabric.
• Direct work history working within Agile, Scrum, DevOps, or DataOps development methodologies, including Azure DevOps for project management, CI/CD, and deployment automation.
• Experience with data governance, security, and compliance solutions including Microsoft Purview, Azure role-based access control (RBAC), and Fabric security models.
• Ability to collaborate with business stakeholders, data engineers, analysts, and solution architects to define data requirements and deliver scalable analytics solutions.
• Willingness to travel four to six times per year with no more than 24 days away from home in a calendar year.
• This remote role is only open to individuals that reside in one of the following states at the time of application: Wisconsin, Illinois, Iowa, Michigan, Ohio, Indiana, North Carolina, Arkansas, Arizona, Florida or South Dakota.

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Family Leave (Maternity, Paternity)
• Long Term Disability
• Training & Development
• Work Life Balance
• No company politics.
• Strong employee focused culture.