What are the responsibilities and job description for the Senior Data Reporting Engineer position at Chamberlain Advisors?
Title: Senior Data Reporting Engineer
Location: Deerfield, IL (Hybrid-3 days onsite)
Duration & Type: 6-Month Contract with Potential for Extension or Full-Time Conversion – Hours, Mon-Fri: 8-5pm CST
Compensation: Competitive hourly W2 rate ($51-$53.50 p/h), Access to Healthcare & Dental Insurance Plan of Choice (details available upon request)
Summary
We are seeking a Senior Data Reporting Engineer to design, develop, and optimize scalable data and reporting solutions that transform complex datasets into reliable, actionable business insights. This position will play a key role in building the data infrastructure, pipelines, models, and reporting layers that support enterprise analytics, business intelligence, and operational decision-making.
The ideal candidate combines strong data engineering expertise with enterprise reporting and BI experience, including advanced SQL, ETL/ELT development, data warehousing, Microsoft Azure, Databricks, and Power BI. This individual will partner closely with business stakeholders, analysts, BI developers, and technical teams to translate reporting requirements into scalable technical solutions.
Click Apply Now To Join The Chamberlain Experience.
What You Will Be Accountable For
Chamberlain Advisors is a veteran-owned business that provides human capital solutions across a wide range of industries and engagement types. Chamberlain candidates benefit from our unique hiring and interviewing process which has been designed to increase the likelihood that they will be successful in their job searches. This is achieved through our 5-step recruitment process, ensuring a top-of-the-line candidate experience. Find out what makes us different; apply to Chamberlain today.
Equal Employment Opportunity
Chamberlain Advisors provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Chamberlain Advisors complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
Chamberlain Advisors expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Chamberlain Advisors' employees to perform their job duties may result in discipline up to and including discharge.
Location: Deerfield, IL (Hybrid-3 days onsite)
Duration & Type: 6-Month Contract with Potential for Extension or Full-Time Conversion – Hours, Mon-Fri: 8-5pm CST
Compensation: Competitive hourly W2 rate ($51-$53.50 p/h), Access to Healthcare & Dental Insurance Plan of Choice (details available upon request)
Summary
We are seeking a Senior Data Reporting Engineer to design, develop, and optimize scalable data and reporting solutions that transform complex datasets into reliable, actionable business insights. This position will play a key role in building the data infrastructure, pipelines, models, and reporting layers that support enterprise analytics, business intelligence, and operational decision-making.
The ideal candidate combines strong data engineering expertise with enterprise reporting and BI experience, including advanced SQL, ETL/ELT development, data warehousing, Microsoft Azure, Databricks, and Power BI. This individual will partner closely with business stakeholders, analysts, BI developers, and technical teams to translate reporting requirements into scalable technical solutions.
Click Apply Now To Join The Chamberlain Experience.
What You Will Be Accountable For
- Design, develop, and maintain scalable data solutions supporting enterprise reporting, analytics, dashboards, and KPI measurement.
- Build and optimize robust ETL/ELT pipelines integrating data from multiple internal and external sources.
- Develop and maintain data models, data marts, dimensional models, semantic layers, and reporting datasets optimized for business intelligence.
- Design reliable data structures that support Power BI and self-service analytics capabilities.
- Partner with business stakeholders to understand reporting requirements and translate business needs into effective technical solutions.
- Support the development and maintenance of enterprise dashboards, scorecards, operational reports, and KPI reporting.
- Develop automated processes supporting data quality, integrity, governance, security, and validation.
- Optimize SQL queries, data architecture, and reporting environments for performance, scalability, and reliability.
- Maintain metadata, technical documentation, data definitions, and data lineage.
- Implement monitoring, alerting, and troubleshooting processes for production data pipelines and reporting systems.
- Collaborate with Data Analysts, BI Developers, application teams, and other technical stakeholders to establish reporting and data engineering best practices.
- Participate in CI/CD and deployment processes supporting enterprise data solutions.
- Evaluate emerging technologies and recommend improvements to existing reporting and analytics capabilities.
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Mathematics, Statistics, or a related technical discipline.
- 5 years of experience in data engineering, reporting engineering, analytics engineering, business intelligence development, or a related area.
- Strong hands-on experience designing and supporting enterprise reporting and data platforms.
- Advanced proficiency with SQL and relational database concepts.
- Experience developing production-level ETL/ELT pipelines and data integration solutions.
- Strong knowledge of data warehousing, dimensional modeling, data marts, and reporting-layer architecture.
- Hands-on experience working within Microsoft Azure cloud environments.
- Experience with Databricks, Apache Spark, and Python for data processing and transformation.
- Experience developing or supporting reporting solutions using Power BI or comparable enterprise BI platforms.
- Strong understanding of data governance, data quality, security, metadata, and data lineage.
- Experience with CI/CD and Azure DevOps is highly preferred.
- Strong analytical, troubleshooting, and problem-solving capabilities.
- Excellent communication skills with the ability to work effectively across both technical and business teams.
Chamberlain Advisors is a veteran-owned business that provides human capital solutions across a wide range of industries and engagement types. Chamberlain candidates benefit from our unique hiring and interviewing process which has been designed to increase the likelihood that they will be successful in their job searches. This is achieved through our 5-step recruitment process, ensuring a top-of-the-line candidate experience. Find out what makes us different; apply to Chamberlain today.
Equal Employment Opportunity
Chamberlain Advisors provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Chamberlain Advisors complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
Chamberlain Advisors expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Chamberlain Advisors' employees to perform their job duties may result in discipline up to and including discharge.
Salary : $51 - $54