Position :: Data & Analytics Manager
Location :: 100% Remote
Duration :: 6+ months
Interview :: Video
Job Description:
Position Summary
The Data & Analytics Manager is responsible for leading the design, delivery, and governance of the company’s enterprise data environment. This role ensures data from multiple systems flows through our Bronze → Silver → Gold lakehouse architecture, arrives in business-ready data marts, and powers standardized Power BI semantic models used across the organization.
This is a hands-on player–coach role providing architectural direction, defining technical standards, managing the offshore data engineering partner, and guiding Power BI analysts to build scalable, governed, and reusable analytics assets.
Key Responsibilities
Architecture & Framework Ownership
• Own and maintain the company’s data architecture spanning Azure Data Lake, Synapse Serverless SQL, and Power BI.
• Enforce architectural standards for Bronze (raw), Silver (enriched), Gold (conformed/data marts) layers.
• Define and maintain data contracts, conformed dimensions, surrogate key strategy, and domain boundaries.
• Drive standardization of fact and dimension table naming, grains, lineage, and quality checks.
Data Delivery & Modeling
• Lead the creation and enhancement of Gold Layer data marts for Sales, Finance, Workforce, and Operations.
• Design and approve Power BI semantic models for each domain, ensuring business-friendly usability.
• Direct handling of new data sources: onboarding, normalization, conformance, and surfacing to marts & models.
• Review and approve SQL, data transformations, and semantic models for technical accuracy and scalability.
Team Leadership & Vendor Management
• Lead and mentor the internal Power BI Analyst team (2) and manage the offshore vendor’s backlog and priorities.
• Translate business requests into structured build requirements aligned to the architecture.
• Reduce dependency on temporary analyst-built logic by embedding patterns and upskilling the team.
• Set quarterly objectives, delivery expectations, and quality standards for the offshore engineering vendor.
Governance, Quality, & Enablement
• Establish lightweight governance standards: data dictionary updates, semantic model certification, lineage tagging.
• Maintain definitions for KPIs, metrics, and shared dimensions; prevent “report-specific datasets”.
• Partner with business functions (Sales, Finance, Operations) to convert requirements into scalable data assets.
• Champion a self-service analytics approach by enabling report authors to use certified semantic models.
Continuous Improvement
• Own the roadmap for retiring legacy data structures (e.g., fct.invoice_header) and migrating to conformed models.
• Implement monitoring and quality controls ensuring data reliability and timeliness.
• Recommend tools, processes, and training to advance analytics maturity.
Required Qualifications
• 5+ years in data engineering, analytics, business intelligence, or data architecture roles.
• Strong experience in Microsoft Azure (ADLS Gen2, Synapse Serverless SQL, pipelines, Delta/Parquet).
• Expertise in dimensional modeling, conformed dimensions, star schema, and semantic model design.
• Proficient with Power BI datasets, relationships, calculation groups, DAX fundamentals, and data modeling.
• Demonstrated ability to lead architecture decisions and enforce standards in a collaborative way.
• Experience directing offshore or vendor partners.
Preferred Qualifications
• Experience with multi-ERP environments and merging data across systems.
• Background designing surrogate key strategies, keymap schemas, and SCD2 dimensions.
• Familiarity with Azure DevOps pipelines, CI/CD for analytics, Git, or DBT/Fabric/Databricks (nice to have).
• Experience operationalizing enterprise semantic models for executive reporting.