Data Warehouse Developer

Menards; Eau Claire (WI); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Profit Sharing & 401K

Team Member Discount

Paid Vacation & Holidays

Job summary

Menards is seeking a Data Warehouse Developer to design, develop, and implement BI and data management solutions for the Enterprise Data Warehouse. You will partner with architects and business partners to shape the technical vision across applications in our data warehouse environment.

You will design semantic models, ETL/ELT workflows, and dashboards; optimize performance and ensure data quality. Role requires collaboration with technical and business teams and willingness to work standard

Qualifications

• Bachelor or Associate degree in an analytical related field (CS/IT/data engineering).
• 1+ years’ experience developing SQL code.
• Experience testing for QA, administering and monitoring database technologies.
• Strong analytical, consultative, and communication skills with both technical and business personnel.
• Experience with DB/ETL/BI tools (Postgres, PySpark, MicroStrategy).
• Must work standard office hours Mon–Fri at Corporate Office in Eau Claire, WI; remote/hybrid not available.

Responsibilities

• Design, develop, and maintain enterprise BI solutions with focus on Strategy and semantic models, cubes, reports, dashboards, and visualizations.
• Design and support ETL/ELT workflows, implement business rules, ensure data quality and integrity.
• Optimize ETL processes and reports for target execution times.
• Collaborate with stakeholders to translate reporting requirements into BI solutions.
• Develop program specifications, write code, test changes, and implement them.
• Develop test plans and thoroughly test and debug code prior to implementation.
• Monitor, tune, and analyse database performance.

Skills

Analytical skills

Communication

Consultative

SQL development

Education

Bachelor or Associate's degree in analytical field

Tools

PySpark

MicroStrategy

Postgres

Oracle

SQL Server

Informix

Job description

• Profit Sharing & 401K, Paid Vacation & Holidays
• Team Member Discount
• Highly collaborative work environment
• Monday – Friday work week
• Pay based on experience

Job Description

Why Work for Menards?

• Profit Sharing & 401K, Paid Vacation & Holidays
• Team Member Discount
• Highly collaborative work environment
• Monday – Friday work week
• Pay based on experience

Position Summary

The Data Warehouse Developer is responsible for the design, development, and implementation of Business Intelligence and Data Management solutions to meet the business needs of Menard’s Enterprise Data Warehouse. You will work with architects and business partners to fashion the technical vision for various applications in our Data Warehouse environment.

Primary Responsibilities

• Design, develop, and maintain enterprise Business Intelligence solutions with a primary focus on Strategy, including the creation of semantic models, intelligent cubes, reports, dashboards, documents, dossiers, prompts, metrics, attributes, transformations, and visualizations.
• Design and support ETL/ELT workflows, implement business rules, and ensure data quality, integrity, and consistency throughout the data pipeline.
• Optimize ETL processes, existing reports and new programs to fit into a desired execution time frame.
• Collaborate with business stakeholders to translate reporting and analytics requirements into high-performing BI solutions.
• Actively participate in developing program specifications, writing code, testing and implementing program changes and program development.
• Develop test plans and thoroughly test and debug all code prior to implementation.
• Carry out monitoring, tuning, and database performance analysis.

Preferred Experience

• Bachelor or Associates degree in an Analytical related field; including Computer Science, Software Development, Information Technology, Data Engineering or related work experience.
• One or more years’ experience developing SQL Code.
• Testing for quality assurance, administering, and monitoring of database technologies.
• Strong analytical, consultative, and communication skills; as well as the ability to work with both technical and business personnel.
• Experience with database technologies (Postgres a plus) or ETL tools (PySpark a plus) or business intelligence tools (MicroStrategy a plus).
• Must work within designated normal office hours - Monday-Friday, 40 hours/week - at the Corporate Office in Eau Claire, WI. Remote/hybrid work is not available.
• Must be willing to work overtime as needed (including overnight on-call 2-3 times per year).
• Candidates must be eligible to work in the United States, presently and in the future, without sponsorship.

Technical Skillsets

• SQL: Postgres, Oracle, SQL Server, Informix
• Strategy
• PySpark, Python