Data Engineer #1065869

Fasttek; Livonia (MI); Hybride; USD 120 000 - 180 000; Plein temps

Avantages offerts par ce poste

Medical and Dental

Vision

PTO

Long Term Disability

Life Insurance

401(k) with match

Résumé du poste

FastTek Global is seeking an experienced Data Engineer in Livonia, MI, to lead analytics initiatives and build enterprise-scale Power BI models and BigQuery pipelines. You will partner with stakeholders to deliver high-value insights, optimize data transformations, and enforce BI governance.

The role emphasizes semantic modeling, performance tuning, and CI/CD for BI assets, with a hybrid onsite work arrangement in a senior data engineering capacity.

Qualifications

• 10+ years of Business Intelligence experience with focus on Power BI and enterprise reporting.
• Strong SQL skills and experience optimizing queries in Google BigQuery.
• Experience designing enterprise semantic models using star/snowflake schemas and managing BI assets.

Responsabilités

• Lead analytics initiatives and establish best practices for querying and transforming large BigQuery datasets.
• Develop reusable DAX measures, M-query transformations, and aggregation tables for scalable reports.
• Manage Power BI Service workspaces, deployment pipelines, gateways, and refresh schedules.

Connaissances

Power BI semantic modeling

BigQuery optimization

Formation

Bachelor's Degree

Outils

Power BI

Google BigQuery

Dataflow/Airflow

Description du poste

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.

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.

We have been doing this with pride, dedication and plain, old-fashioned hard work for 24 years!

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 [e-mail].