Business Intelligence Engineer

Aquent; Chicago (IL); On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

Health benefits

Paid sick leave

Retirement matching

Job summary

Aquent is partnering with a leading organization to modernize data reporting capabilities, transforming how insights are delivered. Join a team focused on building state-of-the-art Power BI solutions and advanced data modeling to empower business users across operations.

You will lead migration from legacy reporting to modern data sources, design scalable dashboards, and optimize data models for performance on large datasets. Strong communication is essential.

Qualifications

• 5+ years of hands-on experience developing Power BI solutions with data modeling and DAX measures.
• Experience converting/rebuilding SSRS reports into Power BI or Paginated Reports.
• Proven track record transitioning reports to new data sources, updating queries, and redesigning datasets.
• Expertise with T-SQL for validating data sources and rebuilding complex queries.
• Proficiency in Power Query (M) for data shaping and transformation.
• Strong understanding of dataset architecture, model optimization, and performance tuning.
• Excellent written and verbal communication for documenting logic changes and decisions.

Responsibilities

• Lead the transition of existing reporting solutions to updated data sources and platforms.
• Architect and develop Power BI solutions including data models, DAX measures, and intuitive dashboards.
• Convert legacy SSRS reports to Power BI or Paginated Reports.
• Update queries, validate data logic, and redesign datasets during migrations.
• Utilize T-SQL to validate data sources and rebuild complex queries.
• Collaborate with stakeholders to analyze existing logic and identify improvements in Power BI.

Skills

Power BI

DAX

Data modeling

Report design

SSRS/Paginated reporting

T-SQL

Power Query (M)

Large datasets

Communication

Tools

Power BI

SSRS

Paginated Reports

Power Query (M)

SQL

Job description

Aquent is partnering with a leading organization dedicated to leveraging data for strategic decision-making and operational excellence. Our client is embarking on an exciting journey to modernize their data reporting capabilities, transforming how critical business insights are delivered across their operations. This is a unique opportunity to join a team that values innovation and impact, where your expertise will directly contribute to enhancing their analytical infrastructure and empowering their business users with state-of-the-advanced reporting solutions.

To be considered for this role, you must:

• Be authorized to work in the United States
• Not require sponsorship of any kind for the duration of the assignment
• Be able to work on a W-2 basis. C2C or 1099 is not permitted for this position

Make a Transformative Impact as a Business Intelligence Engineer!

Are you a highly skilled Business Intelligence Engineer with a passion for data transformation and a knack for building powerful, insightful reporting solutions? We are seeking a dynamic individual to play a pivotal role in our client’s modernization efforts. You will be at the forefront of transitioning existing reporting solutions to cutting-edge data sources and platforms, directly influencing how the organization understands and acts upon its data. This role offers the chance to apply your advanced Power BI and SQL expertise to solve complex challenges, architect robust data models, and deliver high-quality, actionable intelligence that drives strategic outcomes.

What You’ll Do:

• Lead the transition of existing reporting solutions to updated data sources and platforms, ensuring seamless migration and enhanced functionality.
• Apply your in-depth understanding of Power BI, DAX, and SSRS/Paginated reporting to evaluate and re-engineer complex reporting logic and data models.
• Architect and develop sophisticated Power BI solutions, including data modeling, DAX measure creation, and intuitive report and dashboard design.
• Drive the conversion and rebuilding of legacy SSRS reports into modern Power BI or Paginated Reports.
• Update and optimize queries, validate data logic, and redesign datasets when transitioning reports to new data sources.
• Utilize T‑SQL extensively for validating data sources, rebuilding complex queries, and understanding the structure of legacy datasets.
• Shape and transform data efficiently using Power Query (M) to ensure data quality and readiness for reporting.
• Optimize dataset architecture, model relationships, and performance to handle large and complex datasets effectively.
• Collaborate with stakeholders to analyze existing reporting logic, accurately replicate it, and identify opportunities for improvement within Power BI or Paginated Reports.
• Exercise considerable latitude in determining technical approaches, requirements, and work sequencing to meet critical delivery timelines.

Must-Have Qualifications:

• 5 or more years of hands‑on experience developing Power BI solutions, including robust data modeling, intricate DAX measure creation, and compelling report/dashboard design.
• Advanced experience in converting or rebuilding SSRS reports into Power BI or Paginated Reports.
• Proven experience transitioning reports to new data sources, encompassing updating queries, validating logic, and redesigning datasets.
• Expertise with T‑SQL for validating data sources, rebuilding queries, and thoroughly understanding legacy SSRS datasets.
• Proficiency in Power Query (M) for efficient data shaping and transformation.
• Strong understanding of dataset architecture, model optimization, relationships, and performance tuning.
• Demonstrated ability to analyze existing reporting logic and accurately replicate or improve it in Power BI or Paginated Reports.
• Experience working with large and complex datasets.
• Exceptional verbal and written communication skills for documenting requirements, logic changes, and technical decisions.

Nice-to-Have Qualifications:

• Advanced proficiency in DAX, including time‑intelligence, advanced modeling patterns, and calculation optimization techniques.
• Experience building enterprise‑grade Power BI semantic models or reusable datasets.
• Proficiency with Power BI Report Builder for paginated report development.
• Familiarity with the migration of reporting solutions within large enterprise environments.

About Aquent Talent:

• Aquent Talent connects the best talent in marketing, creative, and design with the world’s biggest brands.
• Aquent’s eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match.

Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We’re about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.