Data Engineer

Akkodis; Dearborn (MI); Hybrid; USD 69,000 - 76,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Short-term disability

Commuter benefits

401K plan

EAP program

Job summary

Akkodis is seeking a Data Engineer in Dearborn, MI to drive enterprise BI initiatives using Power BI and Google BigQuery. You will lead semantic modeling, reporting, and data architecture efforts, collaborating with business and tech stakeholders to turn complex data into actionable insights.

The role requires 7+ years in data engineering with strong BI capabilities, in a hybrid onsite/remote setup (4 days on site, 1 day WFH). Competitive hourly rate offered, not on C2C.

Qualifications

• 7+ years of Data Engineering experience delivering enterprise BI solutions.
• Advanced expertise in Power BI including semantic modeling, DAX, and Power Query.
• Strong BigQuery experience and data warehousing knowledge.

Responsibilities

• Design and maintain Power BI semantic models and high-performing reports/dashboards.
• Develop and optimize BigQuery SQL queries and ETL/ELT processes.
• Establish data architecture standards, governance, and performance optimization across analytics.

Skills

Power BI

Google BigQuery

DAX

Power Query

SQL

Data modeling

ETL/ELT

Performance tuning

Data governance

Education

Bachelor's Degree in CS/IT/Data/Analytics

Tools

Power BI Service

BigQuery

Job description

Akkodis is seeking a Data Engineer for one of our clients in Dearborn, MI.

Rate Range: $50.00 to $55.00/hour; the rate may be negotiable based on experience, education, geographic location, and other factors.

We are seeking a highly experienced Data Engineer to support the design, development, and delivery of enterprise reporting and analytics solutions. This role will serve as a technical leader for Power BI and Google BigQuery initiatives, partnering with both business and technical stakeholders to transform complex data into meaningful insights that drive decision-making.

The successful candidate will be responsible for building and maintaining scalable Power BI semantic models, developing high-performing reports and dashboards, and optimizing large datasets within BigQuery. This position will play a key role in establishing data architecture standards, reporting best practices, governance processes, and performance optimization strategies across the analytics environment.

Responsibilities include designing and supporting semantic models using dimensional modeling principles; developing DAX measures, Power Query transformations, calculation groups, aggregation tables, and incremental refresh solutions; writing and optimizing complex BigQuery SQL queries; supporting data warehousing and ETL/ELT initiatives; implementing data quality and validation processes; managing Power BI administration, security, deployments, and refresh schedules; and driving performance improvements across reporting platforms.

We are currently working 4 days per week onsite with 1 day WFH.

Please note, we are not able to work on C2C basis for this opportunity.

Requirements

• 7+ years of Data Engineering experience and significant experience delivering enterprise Business Intelligence solutions.
• Advanced expertise in Microsoft Power BI, including semantic modeling, DAX, Power Query (M), data modeling, composite models, and enterprise reporting.
• Strong experience developing and optimizing solutions within Google BigQuery.
• Deep understanding of data warehousing, dimensional modeling, ETL/ELT processes, and data pipeline architecture.
• Experience designing and maintaining star and snowflake schemas for scalable reporting solutions.
• Ability to optimize report and query performance using aggregation strategies, incremental refresh, query folding, partitioning, and performance analysis tools.
• Experience administering Power BI Service, including workspace management, security, gateways, deployment pipelines, publishing, and refresh management.
• Knowledge of data governance, access controls, row-level security, object-level security, and reporting compliance practices.
• Experience partnering with business stakeholders to gather requirements, define KPIs, document reporting logic, and translate business needs into technical solutions.
• Strong SQL development and troubleshooting skills.
• Proven ability to lead user acceptance testing, data reconciliation, documentation, and end-user training efforts.
• Excellent communication, analytical, problem-solving, and stakeholder management skills.
• Ability to work effectively in Agile and cross-functional team environments.

Preferred Qualifications

• Experience with Google Cloud Platform services such as Dataflow, Cloud Composer, or Airflow.
• Python programming experience for data engineering, automation, or analytics initiatives.
• Experience with CI/CD pipelines and version control processes for BI and analytics assets.
• Background in business analysis or requirements management.
• Experience supporting enterprise data governance and self-service analytics programs.

Education

• Bachelor's Degree in Computer Science, Information Technology, Data Engineering, Analytics, or a related technical discipline.
• Relevant Microsoft, Google Cloud, or Data Engineering certifications are preferred.

Equal Opportunity Employer/Veterans/Disabled

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable.

To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit:

https://www.modis.com/en-us/candidate-privacy/

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

The California Fair Chance Act

Los Angeles City Fair Chance Ordinance

Los Angeles County Fair Chance Ordinance for Employers