Job Description
Our client, a Media, Information and Services company, is looking for a Analytics Engineer for their Charlotte , NC/Hybrid location.
Responsibilities:
Requirements:
Why Should You Apply?
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
Numbers & Facts
| Location | Charlotte, NC |
| Industry | Management Consulting Services |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | https://www.iconma.com/ |
Benefits
401K, Employee Referral Program, Life Insurance
About Company
ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.
- Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
- Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
- Founded in 2000
- 2000+ Employees
The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.
Skills
- Artificial Intelligence (AI)unmatched
- Artificial Intelligence (AI) Agentsunmatched
- Best Practicesunmatched
- Broadcastingunmatched
- Business Analysisunmatched
- Cloud Computingunmatched
- Continuous Deployment/Deliveryunmatched
- Continuous Integrationunmatched
- Cross-Functionalunmatched
- Data Managementunmatched
- Data Modelingunmatched
- Data Structuresunmatched
- DevOpsunmatched
- Dimensional Modelingunmatched
- Entertainment and Mediaunmatched
- Financeunmatched
- Gitunmatched
- Health Planunmatched
- Information/Data Security (InfoSec)unmatched
- Logic Designunmatched
- Maintain Complianceunmatched
- Microsoft Product Familyunmatched
- Partner Salesunmatched
- Performance Tuning/Optimizationunmatched
- Power BIunmatched
- Requirements Managementunmatched
- Root Cause Analysisunmatched
- SQL (Structured Query Language)unmatched
- Scala Programming Languageunmatched
- Star Schemaunmatched
- Team Playerunmatched
- Technical Leadershipunmatched
- Test Dataunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder