The Lead Data Modeling Engineer is responsible for designing and developing advanced data models and visualizations, with a strong focus on technical excellence and team leadership. This role requires a deep technical background in data modeling, database design, and data visualization tools like Power BI.
ESSENTIAL DUTIES AND RESPONSIBILITIES - Architecting and engineering complex data models and visualization solutions.
- Leading and mentoring a team of data engineers and analysts.
- Developing and maintaining data models to support business intelligence and analytics.
- Implementing advanced data transformations using DAX and M.
- Ensuring data integrity, performance optimization, and scalability.
- Collaborating with engineers, and business stakeholders to integrate data from various sources.
- Establishing best practices and standards for data modeling and visualization.
- Conducting code reviews and providing technical guidance to team members.
- Automating report delivery and ensuring timely distribution of insights.
- Implementing automated testing frameworks to ensure data quality and reliability.
- Utilizing CI/CD pipelines to streamline the deployment of data models and visualizations.
- Staying updated with the latest technologies and trends in data modeling and visualization.
EDUCATION, QUALIFICATIONS, EXPERIENCE - Bachelor's degree preferred in a technical field, preferably in Computer Science, Math, Engineering, or MIS.
- 7+ years of experience with Microsoft data platform technology.
- Experience building and troubleshooting solutions using SSIS and SSRS.
- Proficiency in TSQL programming (stored procedures, functions, triggers, query plan analysis, etc.).
- Experience with Microsoft Power BI platform, including DAX programming, Power BI dataflow, model, and report development.
- Proven ability to troubleshoot issues in production and perform root cause analysis.
- Strong organizational skills and the ability to multi-task, organize, prioritize, and meet deadlines.
- Strong interpersonal and communication skills.
Work Environment: - This is a hybrid position that requires 3 days per week in our Schaumburg, IL office
Salary: $ 125,000 to $160,000, depending on experience
Benefits: - Medical, Dental, and Vision Insurance
- 401(k)
- Short and Long-term disability
- Life Insurance
- Employee Assistance Program
- Free onsite fitness center membership
- Long-term incentive plan
- Educational Assistance and rewards program
- Paid Time Off
- Paid Holidays
- Paid parental leave