Lead Data Modeling Engineer

Job Description

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.

ESSENTIAL SKILLS

Data Modeling and Design: Creating conceptual, logical, and physical data models.

Database Management: Expertise in SQL and NoSQL databases, data warehousing, and ETL processes.

Cloud Computing: Knowledge of cloud platforms like AWS, Azure, and Google Cloud.

Data Governance and Compliance: Understanding of data privacy laws and best practices for data security.

Programming Languages: Skills in Python, Java, and R.

Data Integration: Experience with data integration tools and techniques.

Performance Tuning: Optimizing database performance and scalability.

Analytical Thinking: Strong problem-solving abilities and critical thinking.

Communication: Conveying complex technical concepts to non-technical stakeholders.

Leadership: Leading and mentoring teams, and managing projects effectively.

Strategic Planning: Aligning data architecture with business goals and future needs.

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

Full-time

Hybrid remote