Data Engineer

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: 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 #J-18808-Ljbffr Akkodis