Data & Analytics Manager || 100% Remote (W2 Role)

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.