SR Analytics Engineer
Arnex Solutions LLC
Dice Job Match Score™
📊 Calculating match score...
Job Details
Skills
- BUSINESS ANALYST
- DATA MODELING
- POWER BI
- DEVOPS
Summary
Job Description
We are hiring an Analytics Engineer. The ideal candidate will act as the vital bridge between raw data and executive insights. You will take "Bronze" data and transform it into high-value Silver (Cleansed) and Gold (Aggregated) layers. Your 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 our Power BI dashboards and AI Data Agents. This role ensures our 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 our 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 our 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 Hearst’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.
- 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.
- Familiarity with governance, security best practices, and performance tuning in a cloud environment.
- Experience in the media or broadcasting industry is a plus.
- Knowledge of serverless architectures and containerized deployment.
- Dice Id: 91124621
- Position Id: 350-38988-
- Posted 9 hours ago
Company Info
About Arnex Solutions LLC
At Arnex Solutions LLC, we go beyond traditional consulting. We blend expertise with innovation to offer end-to-end solutions that bridge the gap between business challenges and technological advancements.
Our Services:
Strategic IT Advisory: Our experienced consultants collaborate with you to craft customized IT strategies that drive growth and efficiency. We transform technology into a competitive advantage.
Talent Resourcing: Access top IT talent with ease. Our staffing solutions connect you with skilled professionals who align with your unique business requirements.
Cloud Excellence: Leverage the power of the cloud with our tailored services. From strategy to execution, we help you harness cloud capabilities for innovation and scalability.
Why Choose Arnex Solutions LLC:
Holistic Approach: We're your all-in-one partner for both strategic consulting and talent acquisition. Our holistic solutions ensure your business stays ahead in a dynamic landscape.
Client-Centric Philosophy: Your success is at the heart of everything we do. Our collaborative approach ensures we understand your unique needs and deliver impactful solutions.
Innovation Infused: We embrace emerging technologies to drive innovation. Partnering with Arnex Solutions LLC means accessing solutions that position you for sustained success.
Enduring Partnerships: Our commitment extends beyond a single project. When you choose Arnex Solutions LLC, you choose a partner dedicated to your long-term growth.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs