Sr. Data Engineer

The Sr. Data Engineer will play a pivotal role in building and operationalizing the data necessary for enterprise analytics initiatives while leveraging industry standard practices and tools. They will collaborate with the Enterprise Analytics Architect in building, managing, and optimizing data pipelines and then deploying these data pipelines effectively into production for consumers across the enterprise. The Data Engineer will be responsible for developing, implementing, and maintaining ETL/ELT processes, data models, and reports/dashboards that meet the organization's data analysis and visualization needs. They will collaborate with business users and subject matter experts to gather requirements, analyze business data, and create reporting that provides actionable insights and inform decision-making.

What you'll do: 

• Collaborate with Enterprise Analytics Architect to design and build data pipelines from key services, applications, and systems. Maintain and optimize the data pipelines to ensure relevant information is highly available and accurate.
• Work closely with business stakeholders to gather requirements and understand business needs.
• Analyze and manipulate complex data resources to provide valuable insights and inform business decision.
• Implement best practices for data warehousing, data integration, and data quality to ensure data accuracy and consistency.
• Troubleshoot and resolve data quality and pipeline issues, and work proactively to prevent recurrent data issues.
• Design and develop data models, reports, and dashboards using report development platforms and tools.
• Utilize Azure cloud technologies and services such as Azure Data Factory, Data Lake Storage, Synapse Analytics, Analysis Services, and DevOps to design, develop, and deploy scalable and reliable data solutions.
• Utilize Microsoft cloud tools and services such as Power Platform, Power Automate, Power Apps and Dataverse to develop and administer data-driven solutions that integrate with Microsoft Dynamics 365, Salesforce and other core business and analytics services.
• Design, develop, and maintain ETL/ELT processes using SSIS to extract, transform, and load data from various sources into the data warehouse.
• Develop, maintain, and enhance multidimensional data models and analysis cubes using SSAS to provide fast and efficient end user data analysis.
• Keep current with industry trends and best practices in data engineering, business intelligence, analytics, data warehousing and data visualization.

Requirements

What you'll bring: 

• Bachelor’s degree in computer science, Information Systems, related technical field, or equivalent experience in an enterprise organization.
• 5+ years of experience working in roles involving data engineering, data analytics, data warehousing, business intelligence or a related field.
•   Relevant Microsoft Azure or other industry certifications and technical training is a plus.  
• Experience working with data related to manufacturing industries is desirable.
• Experience working as a DBA or working knowledge of RDBMS is desirable.

Benefits

All benefits start on first day of employment!

• 75% employer-paid medical for employee. Family coverage also included. 
• 100% employer paid dental, and vision for employee and dependents
• 100% employer paid long-term, short-term disability, and life insurance policy
• 401k Match, if you’re contributing 5% we match 4%. 100% vested immediately.
• 10 paid holidays
• Starting at 15 days paid PTO (inclusive of sick and vacation time) annually
• Employee Assistance Program (EAP)
• Flexible Spending Account (FSA)