Job description

• Lead enterprise-scale ETL and Power BI initiatives with real business impact. • Competitive compensation, long-term growth potential and strong benefits. About Our Client Our client is a highly successful North American organization recognized for its industry leadership, operational scale and strong financial performance. Supporting thousands of employees and customers across multiple distribution and corporate locations, the company continues to invest heavily in data, analytics and technology modernization. This is an opportunity to join a stable, growth-oriented organization where data is viewed as a strategic asset and technology teams are empowered to drive meaningful business outcomes. Job Description Design, develop and maintain enterprise ETL and data integration solutions. Build scalable data pipelines to support reporting, analytics and business intelligence initiatives. Develop and enhance Power BI reports, dashboards and data models. Design and support enterprise data warehouse solutions. Partner with business stakeholders to gather requirements and translate them into technical solutions. Collaborate with cross-functional teams to develop, test and deploy data solutions. Perform ETL testing, code reviews and performance optimization to ensure reliable and scalable solutions. Troubleshoot and resolve complex data integration, performance and data quality issues. Establish and promote ETL development standards and best practices. Provide technical leadership, mentorship and guidance to other members of the data team. MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law. MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants. The Successful Applicant Bachelor's degree in Information Technology, Computer Science or a related field. 8+ years of experience in ETL development, data engineering or data warehousing. Strong hands-on Informatica experience is required. 5+ years of experience designing, developing and supporting enterprise ETL solutions using Informatica, including workflow development, mappings, transformations, performance tuning and production support. Experience building and supporting large-scale enterprise data integration solutions. Advanced SQL and T-SQL development expertise, including query optimization, performance tuning and troubleshooting. Experience developing Power BI reports, dashboards and semantic data models. Strong understanding of data warehouse architecture, ETL methodologies and data governance best practices. Proven ability to troubleshoot and resolve complex data and integration issues. Strong communication skills with the ability to work effectively across business and technical teams. Experience mentoring team members and providing technical leadership within a data engineering environment. Location: Pleasant Prairie, WI (Greater Chicago Area). Work Arrangement: Fully onsite, 5 days per week in the office. Convenient commuting access from Kenosha, Gurnee, Waukegan, Libertyville, Vernon Hills, Lake Forest, Deerfield and Northbrook. What's on Offer • Employment Type: Contract-to-Hire • Compensation: $60 - $85 an hour depending on experience • State-of-the-art corporate campus with premium onsite amenities • Onsite fitness center, café and walking trails • Opportunity to join a highly stable organization undergoing significant investment in enterprise data, reporting and business intelligence capabilities This position is based on a flagship corporate campus in Pleasant Prairie, WI, ideally located between Chicago and Milwaukee. The site is easily accessible from Kenosha, Gurnee, Waukegan, Libertyville, Vernon Hills, Lake Forest, Deerfield, and Northbrook, providing access to a broad and diverse professional talent pool while maintaining a manageable daily commute. Interested in leveraging your Informatica, Power BI and SQL expertise to drive enterprise-scale data initiatives? Apply today to learn more.

Requirements

Must-haves

Lead enterprise-scale ETL and Power BI initiatives with real business impact.
Competitive compensation, long-term growth potential and strong benefits.
Design, develop and maintain enterprise ETL and data integration solutions.
Build scalable data pipelines to support reporting, analytics and business intelligence initiatives.
Develop and enhance Power BI reports, dashboards and data models.
Design and support enterprise data warehouse solutions.
Partner with business stakeholders to gather requirements and translate them into technical solutions.
Collaborate with cross-functional teams to develop, test and deploy data solutions.
Perform ETL testing, code reviews and performance optimization to ensure reliable and scalable solutions.
Troubleshoot and resolve complex data integration, performance and data quality issues.
Establish and promote ETL development standards and best practices.
Provide technical leadership, mentorship and guidance to other members of the data team.
The Successful Applicant
Bachelor's degree in Information Technology, Computer Science or a related field.
8+ years of experience in ETL development, data engineering or data warehousing.
Strong hands-on Informatica experience is required.
5+ years of experience designing, developing and supporting enterprise ETL solutions using Informatica, including workflow development, mappings, transformations, performance tuning and production support.
Experience building and supporting large-scale enterprise data integration solutions.
Advanced SQL and T-SQL development expertise, including query optimization, performance tuning and troubleshooting.
Experience developing Power BI reports, dashboards and semantic data models.
Strong understanding of data warehouse architecture, ETL methodologies and data governance best practices.
Proven ability to troubleshoot and resolve complex data and integration issues.
Strong communication skills with the ability to work effectively across business and technical teams.
Experience mentoring team members and providing technical leadership within a data engineering environment.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: careers-page
Effort: medium