Data Engineer #1065869

FastTek Global

Livonia (MI)

On-site

USD 120,000 - 160,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical and Dental (FastTek pays major
Vision
PTO Program
Long Term Disability (100% paid)
Life Insurance (100% paid)
401(k) with 3% match

Job summary

FastTek Global in Livonia, Michigan is seeking an experienced Data Engineer with a focus on Power BI semantic modeling and Google BigQuery to lead analytics initiatives and deliver enterprise-grade BI assets.

You will design semantic models, optimize BigQuery SQL, and collaborate with stakeholders to implement scalable data pipelines and governance, while advancing reporting performance and data quality.

Qualifications

  • 10+ years of BI experience with Power BI and enterprise reporting.
  • Strong Power BI semantic modeling, DAX, and Power Query (M).
  • Solid SQL skills and optimization in Google BigQuery.
  • Experience with data warehousing, ETL/ELT, dimensional modeling, and pipelines.
  • Experience with Power BI Service administration, security and refresh optimization.
  • Excellent analytical and communication skills; ability to work in a team and agile environment.

Responsibilities

  • Lead analytics initiatives and establish best practices for querying large BigQuery datasets.
  • Design and maintain enterprise semantic models using star/snowflake schemas.
  • Develop reusable DAX measures, M-transformations, and aggregation tables.
  • Collaborate with stakeholders to deliver high-performance insights and governance.

Skills

Power BI
BigQuery
DAX
SQL
ETL/ELT
Data Modeling
Python
Data Governance
Data Warehousing
Cloud Dataflow/Airflow
DAX Studio
Tabular Editor

Education

Bachelor's degree in Computer Science / Information Technology

Tools

Power BI
Google BigQuery
DAX Studio
Tabular Editor
VertiPaq Analyzer
Dataflow
Airflow

Job description

Livonia, Michigan Data Engineer #1065869
Position Description:
  • We are seeking an experienced Data Engineer with strong expertise in Power BI semantic modeling and Google Cloud BigQuery.
  • The ideal candidate has 10+ years of experience in data engineering and business intelligence, with a proven track record of building and optimizing enterprise-scale Power BI models, reports, and dashboards.
  • In this role, you will lead analytics initiatives, establish best practices for querying and transforming large BigQuery datasets, and partner with business and technical stakeholders to deliver high-performance, actionable insights.
  • Power BI Semantic Modeling Design and maintain enterprise semantic models using star and snowflake schemas. Select appropriate storage modes, including Import, DirectQuery, Dual, Direct Lake, and composite models.
  • Develop reusable, well-documented DAX measures, calculation groups, M-query transformations, role-playing dimensions, incremental refresh, and aggregation tables.
  • Promote certified shared datasets, thin reports, consistent business definitions, and model documentation standards. BigQuery and Data Engineering Develop and optimize complex BigQuery SQL, including CTEs, window functions, and large-scale joins.
  • Apply best practices for partitioning, clustering, views, materialized views, query performance, and cost management. Partner with data engineers on ETL/ELT pipelines, curated data layers, and dimensional models.
  • Build reporting-ready BigQuery tables or views, with heavy transformations performed upstream where appropriate. Implement data validation, reconciliation, and quality rules.
  • Understand orchestration and pipeline concepts; experience with Dataflow, Cloud Composer/Airflow, or Python is a plus.
  • Performance, Administration, and Governance Optimize reports and models using tools such as Performance Analyzer, DAX Studio, Tabular Editor, and VertiPaq Analyzer.
  • Improve refresh performance through query folding, incremental refresh, and efficient partitioning.
  • Manage Power BI Service workspaces, deployment pipelines, gateways, refresh schedules, and capacity.
  • Implement row-level and object-level security and follow governance, access, and compliance standards.
  • Support CI/CD and version control for BI assets, and monitor usage, refresh failures, and capacity. Required Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 10+ years of Business Intelligence experience, with a strong focus on Power BI and enterprise reporting. Advanced Power BI skills, including semantic modeling, DAX, Power Query (M), schema design, composite models, and paginated reports.
  • Strong SQL skills and hands-on experience optimizing queries in Google BigQuery. Solid understanding of data engineering, data warehousing, ETL/ELT, dimensional modeling, and data pipelines.
  • Experience with Power BI Service administration, security, gateways, publishing, and refresh optimization.
  • Experience gathering business requirements, documenting reporting logic, and validating results with stakeholders.
  • Excellent analytical, problem-solving, and communication skills; able to work independently and collaboratively in an agile environment.
  • We are seeking an experienced Data Engineer with strong expertise in Power BI semantic modeling and Google Cloud BigQuery.
  • The ideal candidate has 10+ years of experience in data engineering and business intelligence, with a proven track record of building and optimizing enterprise-scale Power BI models, reports, and dashboards.
  • In this role, you will lead analytics initiatives, establish best practices for querying and transforming large BigQuery datasets, and partner with business and technical stakeholders to deliver high-performance, actionable insights.
  • Power BI Semantic Modeling Design and maintain enterprise semantic models using star and snowflake schemas. Select appropriate storage modes, including Import, DirectQuery, Dual, Direct Lake, and composite models.
  • Develop reusable, well-documented DAX measures, calculation groups, M-query transformations, role-playing dimensions, incremental refresh, and aggregation tables.
  • Promote certified shared datasets, thin reports, consistent business definitions, and model documentation standards. BigQuery and Data Engineering Develop and optimize complex BigQuery SQL, including CTEs, window functions, and large-scale joins.
  • Apply best practices for partitioning, clustering, views, materialized views, query performance, and cost management. Partner with data engineers on ETL/ELT pipelines, curated data layers, and dimensional models.
  • Build reporting-ready BigQuery tables or views, with heavy transformations performed upstream where appropriate. Implement data validation, reconciliation, and quality rules.
  • Understand orchestration and pipeline concepts; experience with Dataflow, Cloud Composer/Airflow, or Python is a plus.
  • Performance, Administration, and Governance Optimize reports and models using tools such as Performance Analyzer, DAX Studio, Tabular Editor, and VertiPaq Analyzer.
  • Improve refresh performance through query folding, incremental refresh, and efficient partitioning.
  • Manage Power BI Service workspaces, deployment pipelines, gateways, refresh schedules, and capacity.
  • Implement row-level and object-level security and follow governance, access, and compliance standards.
  • Support CI/CD and version control for BI assets, and monitor usage, refresh failures, and capacity. Required Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 10+ years of Business Intelligence experience, with a strong focus on Power BI and enterprise reporting. Advanced Power BI skills, including semantic modeling, DAX, Power Query (M), schema design, composite models, and paginated reports.
  • Strong SQL skills and hands-on experience optimizing queries in Google BigQuery. Solid understanding of data engineering, data warehousing, ETL/ELT, dimensional modeling, and data pipelines.
  • Experience with Power BI Service administration, security, gateways, publishing, and refresh optimization.
  • Experience gathering business requirements, documenting reporting logic, and validating results with stakeholders.
  • Excellent analytical, problem-solving, and communication skills; able to work independently and collaboratively in an agile environment.
Skills Required:
  • Business Intelligence
Skills Preferred:
  • Business Analysis
Experience Required:
  • Engineer 3 Exp: 7+ years Data Engineering work experience
Education Required:
  • Bachelor's Degree Hybrid Role 4 days a week onsite
Additional Information:
  • Business Engagement and Requirements Partner with business stakeholders and end users to understand reporting needs, pain points, and decisions the reports must support.
  • Lead requirements workshops and review existing reports to identify gaps, manual processes, and opportunities to consolidate.
  • Define and document KPIs, metrics, business rules, data sources, refresh expectations, and security requirements.
  • Capture report logic, including data grain, filters, exclusions, defaults, hierarchies, drill paths, time intelligence, and treatment of null, negative, cancelled, or reversed records.
  • Translate requirements into functional and technical specifications, mappings, and logical data models. Prioritize the backlog, agree on milestones and acceptance criteria, and lead UAT and reconciliation with source or legacy reports.
  • Provide user training, documentation, and ongoing support.
Additional Info:

At FastTek Global, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories. Also, Doing the right thing is our mantra. We act responsibly, give back to the communities we serve and have a little fun along the way.

FastTek Global is financially strong, privately held company that is 100% consultant and client focused.

We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.

Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include:

  • Medical and Dental (FastTek pays majority of the medical program)
  • Vision
  • Personal Time Off (PTO) Program
  • Long Term Disability (100% paid)
  • Life Insurance (100% paid)
  • 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match

Plus, we have a lucrative employee referral program and an employee recognition culture.

FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, and 2023!

To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork

Follow us on Twitter: https://twitter.com/fasttekglobal

Follow us on Instagram: https://www.instagram.com/fasttekglobal

Find us on LinkedIn: https://www.linkedin.com/company/fasttek

You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/

AI & Hiring Disclosure

We use AI tools to support parts of our hiring process, such as reviewing applications and identifying potential matches. These tools are designed to promote efficiency, consistency, and fairness, and they are always used under human oversight.

All personal data collected is used solely for recruitment purposes, and you have the right to know, access, or request deletion of your data at any time, subject to legal limits.

If AI will be used in a video interview, you'll be informed in advance and asked for your consent, with the option to opt out.

Our tools are regularly reviewed to detect potential bias and to ensure compliance with all applicable laws and our commitment to inclusive hiring.

To learn more or exercise your rights, please contact us at info@fasttek.com.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse Architect 3 #1067833
Data Warehouse Architect 3 #1067833

FastTek Global • Lansing (MI)

On-site
USD 110,000 - 170,000
Medical and Dental (FastTek pays major
Vision
PTO
+3
Data Engineering Engineer 2 #1066442
Data Engineering Engineer 2 #1066442

Fasttek • Dearborn (MI)

On-site
USD 90,000 - 130,000
Medical and Dental
Vision Insurance
PTO Program
+5
Software Engineer #1061088
Software Engineer #1061088

Fasttek • Dearborn (MI)

On-site
USD 120,000 - 150,000
Medical and Dental (FastTek pays major
Vision
PTO Program
+3
Technical Data Analyst #1057432
Technical Data Analyst #1057432

Fasttek • United States

Remote
USD 90,000 - 130,000
Principal Data Engineer #1052690
Principal Data Engineer #1052690

Fasttek • Jackson (MI)

On-site
USD 140,000 - 190,000
Medical and Dental
Vision
Personal Time Off
+3
Software Engineer #1067547
Software Engineer #1067547

FastTek Global • Dearborn (MI)

On-site
USD 90,000 - 130,000
Medical & Dental
Vision
PTO
+3
Software Engineer #1067019
Software Engineer #1067019

FastTek Global • Dearborn (MI)

On-site
USD 90,000 - 140,000
Medical and Dental
Vision
PTO Program
+3
Senior Data Engineer #1052686
Senior Data Engineer #1052686

Fasttek • Jackson (MI)

On-site
USD 120,000 - 150,000
Medical & Dental
Vision
PTO
+5
Software Engineer #1065621
Software Engineer #1065621

Fasttek • Dearborn (MI)

On-site
USD 100,000 - 130,000
Medical and Dental
Vision
Personal Time Off
+3
Software Engineer #1067826
Software Engineer #1067826

FastTek Global • Dearborn (MI)

On-site
USD 90,000 - 130,000