IL
Analytics Engineer
ICONMA, LLC
🇺🇸 United States
Hybrid
1 month ago
- SQL
- Microsoft Fabric
- AI
- Data Modeling
- Power BI
- DAX
- PySpark
- Scala
- Delta Lake
- Devops
- Git
- CI/CD
1 month ago
Â
Responsibilities:
- 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.
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.
- 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.
Why Should You Apply?
- Health Benefits
- Referral Program
- Excellent growth and advancement opportunities
Analytics Engineer · ICONMA, LLC