Calance
Analytics Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Analytics Engineer with a 6-month contract-to-hire in Charlotte, NC, offering $60-$70/hr. Requires 7+ years in analytics, expertise in SQL, Power BI, Spark, and Microsoft Fabric, plus strong data modeling and communication skills.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
560
-
🗓️ - Date
May 5, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
On-site
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
Charlotte, NC
-
🧠 - Skills detailed
#AI (Artificial Intelligence) #Deployment #Compliance #"ETL (Extract #Transform #Load)" #Cloud #DevOps #Spark (Apache Spark) #Data Engineering #Spark SQL #Data Pipeline #Data Lineage #Data Governance #Strategy #Semantic Models #Scala #Data Strategy #PySpark #GIT #DAX #Security #Data Modeling #Leadership #SQL (Structured Query Language) #Microsoft Power BI #Delta Lake #BI (Business Intelligence)
Role description
•
•
• For this position, our client is requiring candidates to be either U.S. Citizen OR Green Card Holder
•
•
• Our client is hiring an Analytics Engineer. The ideal candidate will act as the vital bridge between raw data and executive insights. The resource will take "Bronze" data and transform it into high-value Silver (Cleansed) and Gold (Aggregated) layers. The resource’s primary goal is to codify complex media sales logic such as Revenue Pacing, Share of Wallet, and Yield into high-performance Semantic Models that power Client’s Power BI dashboards and AI Data Agents. This role ensures Client’s data is not just accessible, but actionable and intelligent.
What You’ll Do:
· Medallion Transformation: Use Spark and SQL to architect the Silver and Gold layers of Client’s Lakehouse, ensuring all data is rigorously tested, clean, and documented.
· Semantic Modeling: Design and maintain the Microsoft Fabric Semantic Model (Direct Lake mode) to provide a "Single Source of Truth" across the entire organization.
· Business Logic Codification: Partner closely with Sales and Finance stakeholders to translate "What" and "Why" business questions into precise technical data definitions.
· AI Data Readiness: Structure data specifically for LLM consumption, enabling Client’s AI Data Agents to accurately navigate complex hierarchies of stations, advertisers, and categories.
· Data Governance & Security: Implement Row-Level Security (RLS) and maintain data lineage to ensure compliance with Client’s unified data strategy.
· Technical Leadership: Lead the design of project-specific data models, prepare design specifications, and conduct feature estimations in collaboration with cross-functional teams.
· Optimization & RCA: Perform root cause analysis on anomalies and implement solutions to minimize points of failure and optimize data pipeline performance.
Requirements:
· Experience: 7+ years in business analytics, data modeling, or data engineering (or a Master’s degree with 5+ years of experience).
· Modeling Expertise: 5+ years of deep experience with relational modeling concepts and Microsoft tabular semantic models.
· Technical Proficiency: Expert-level SQL skills and 5+ years of experience with Power BI, DAX, and Spark (Spark SQL/PySpark/Scala).
· Platform Knowledge: Strong hands-on experience with Microsoft Fabric tools and the Delta Lake format.
· Logic & Design: Demonstrated experience translating complex business requirements into technical requirements using Star Schema/Dimensional modeling.
· DevOps: Familiarity with Git, CI/CD, and modern development workflows.
· Communication: Proven ability to collaborate with stakeholders and escalate data requirements or constraints effectively.
Preferred Qualifications:
· Familiarity with governance, security best practices, and performance tuning in a cloud environment.
· Knowledge of serverless architectures and containerized deployment.
Duration: 6 months contract-to-hire
Compensation: $60-$70/hr. DOE (W-2)
Worksite Location: Charlotte, NC (100% On-Site)
•
•
• For this position, our client is requiring candidates to be either U.S. Citizen OR Green Card Holder
•
•
• Our client is hiring an Analytics Engineer. The ideal candidate will act as the vital bridge between raw data and executive insights. The resource will take "Bronze" data and transform it into high-value Silver (Cleansed) and Gold (Aggregated) layers. The resource’s primary goal is to codify complex media sales logic such as Revenue Pacing, Share of Wallet, and Yield into high-performance Semantic Models that power Client’s Power BI dashboards and AI Data Agents. This role ensures Client’s data is not just accessible, but actionable and intelligent.
What You’ll Do:
· Medallion Transformation: Use Spark and SQL to architect the Silver and Gold layers of Client’s Lakehouse, ensuring all data is rigorously tested, clean, and documented.
· Semantic Modeling: Design and maintain the Microsoft Fabric Semantic Model (Direct Lake mode) to provide a "Single Source of Truth" across the entire organization.
· Business Logic Codification: Partner closely with Sales and Finance stakeholders to translate "What" and "Why" business questions into precise technical data definitions.
· AI Data Readiness: Structure data specifically for LLM consumption, enabling Client’s AI Data Agents to accurately navigate complex hierarchies of stations, advertisers, and categories.
· Data Governance & Security: Implement Row-Level Security (RLS) and maintain data lineage to ensure compliance with Client’s unified data strategy.
· Technical Leadership: Lead the design of project-specific data models, prepare design specifications, and conduct feature estimations in collaboration with cross-functional teams.
· Optimization & RCA: Perform root cause analysis on anomalies and implement solutions to minimize points of failure and optimize data pipeline performance.
Requirements:
· Experience: 7+ years in business analytics, data modeling, or data engineering (or a Master’s degree with 5+ years of experience).
· Modeling Expertise: 5+ years of deep experience with relational modeling concepts and Microsoft tabular semantic models.
· Technical Proficiency: Expert-level SQL skills and 5+ years of experience with Power BI, DAX, and Spark (Spark SQL/PySpark/Scala).
· Platform Knowledge: Strong hands-on experience with Microsoft Fabric tools and the Delta Lake format.
· Logic & Design: Demonstrated experience translating complex business requirements into technical requirements using Star Schema/Dimensional modeling.
· DevOps: Familiarity with Git, CI/CD, and modern development workflows.
· Communication: Proven ability to collaborate with stakeholders and escalate data requirements or constraints effectively.
Preferred Qualifications:
· Familiarity with governance, security best practices, and performance tuning in a cloud environment.
· Knowledge of serverless architectures and containerized deployment.
Duration: 6 months contract-to-hire
Compensation: $60-$70/hr. DOE (W-2)
Worksite Location: Charlotte, NC (100% On-Site)
