Business Intelligence Engineer

Skill; United States; On-site; USD 68,000 - 76,000; Full time

Benefits offered by this job

Subsidized health plan

Vision plan

Dental plan

Paid sick leave

Retirement plan with match

Free online training

Job summary

Aquent is partnering with a leading organization to modernize its data reporting capabilities. You will apply Power BI, DAX, and SQL expertise to transform reporting, build robust data models, and deliver actionable insights for strategic decision-making.

The role focuses on migrating existing reports to new data sources and platforms, rebuilding legacy reports, and delivering high-quality dashboards and paginated reports. Strong communication is essential to drive impactful outcomes.

Qualifications

• 5+ years building Power BI solutions with data modeling.
• Expert in converting SSRS reports to Power BI/Paginated Reports.
• Experience migrating reports to new data sources and optimizing data sets.
• Strong T-SQL and Power Query (M) skills.

Responsibilities

• Lead transition of reporting solutions to updated data sources.
• Architect Power BI solutions with data modeling and DAX.
• Migrate legacy SSRS reports to Power BI or Paginated Reports.
• Optimize queries and validate data logic.
• Collaborate with stakeholders to refine reporting requirements.

Skills

Power BI

DAX

Data modeling

Communication

Tools

SSRS

Paginated Reports

T-SQL

Power Query (M)

Power BI Desktop

Job description

Overview

Placement Type:

Temporary

Salary:

$49.65-55.17 Hourly

Start Date:

Oct 5, 2026

Aquent is partnering with a leading organization dedicated to leveraging data for strategic decision-making and operational excellence. This organization 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-art reporting solutions.

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.

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

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 timeintelligence, advanced modeling patterns, and calculation optimization techniques.
• Experience building enterprisegrade 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.

Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium. More information on our awesome benefits!

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.