Senior Data Solutions Analyst – Enterprise Data

This is a remote position.

Must Have:

• Advanced SQL, including CTEs, window functions, complex joins, aggregations, and query optimization.
  

• Enterprise data warehousing and dimensional modeling, including fact and dimension design.
  

• Experience defining enterprise KPIs, business rules, and governed data products.
  

• Power BI semantic modeling, including measures, relationships, hierarchies, and row-level security concepts.
  

• Master Data Management (MDM) or enterprise data governance experience.
  

• Experience translating business requirements into functional specifications and acceptance criteria.
  

• Working knowledge of Azure, Databricks, or similar cloud data platforms.
  

Responsibilities:

• Lead functional design and governance of reusable enterprise data products.
  

• Partner with Finance, Operations, Sales, HR, Product, and Technology teams to define enterprise reporting and analytics requirements.
  

• Conduct business workshops and translate requirements into functional specifications, business rules, and acceptance criteria.
  

• Define, document, and certify enterprise KPIs, including calculations, dimensions, ownership, and change impacts.
  

• Develop advanced SQL queries for data profiling, validation, reconciliation, and business logic testing.
  

• Design governed Gold Layer data products and collaborate with Data Engineering teams on Bronze, Silver, and Gold architectures.
  

• Define requirements for Power BI semantic models, including measures, relationships, hierarchies, and security.
  

• Establish master data rules covering matching, standardization, survivorship, hierarchies, and exception handling.
  

• Work with data owners and stewards to improve data quality and maintain consistent enterprise definitions.
  

• Support governed data consumption through APIs, Power BI, Databricks Genie, and AI-enabled applications.
  

• Evaluate AI use cases for data readiness, governance, business definitions, and validation requirements.
  

• Lead user acceptance testing (UAT), reconciliation, business validation, and data product certification.
  

• Maintain data dictionaries, business glossaries, KPI catalogs, metadata, lineage, and ownership documentation.
  

• Assess downstream impacts of changes to data sources, enterprise metrics, and semantic models.
  

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Business Analytics, Engineering, Finance, or a related field.
  

• Minimum 5 years of experience in Data Analytics, Business Intelligence, Data Solutions, Data Product, Master Data, or Analytics Consulting.
  

• Strong experience writing and optimizing complex SQL queries.
  

• Understanding of dimensional modeling, enterprise data warehousing, and Medallion architecture.
  

• Experience defining production-ready functional requirements and governed business rules.
  

• Experience with Power BI semantic models and enterprise reporting.
  

• Knowledge of master data governance, stewardship, data quality, and business definitions.
  

• Experience leading business requirements workshops, UAT, and data validation.
  

• Ability to coordinate with business stakeholders, data engineers, and BI teams.
  

Nice to Have:

• Experience with Azure Data Lake, Azure Data Factory, Databricks, or Unity Catalog.
  

• Experience supporting AI-enabled analytics, natural-language querying, copilots, or Databricks Genie.
  

• Experience defining enterprise data products used by APIs and AI applications.
  

• Experience managing enterprise KPI catalogs, metadata repositories, and data lineage.