Senior Data Solutions Analyst – Enterprise Data

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee the functional design and governance of reusable enterprise data products.

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

• Facilitate business workshops and convert requirements into functional specifications, business rules, and acceptance criteria.

• Identify, document, and certify enterprise KPIs, including their calculations, dimensions, ownership, and impacts of changes.

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

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

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

• Establish master data rules that encompass matching, standardization, survivorship, hierarchies, and exception management.

• Collaborate with data owners and stewards to enhance data quality and uphold consistent enterprise definitions.

• Provide support for governed data consumption via APIs, Power BI, Databricks Genie, and AI-enabled applications.

• Assess AI use cases for data readiness, governance, business definitions, and validation necessities.

• Direct user acceptance testing (UAT), reconciliation, business validation, and certification of data products.

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

• Evaluate downstream impacts of modifications to data sources, enterprise metrics, and semantic models.

⛳️ Requirements

• Proficient in advanced SQL, including CTEs, window functions, complex joins, aggregations, and query optimization.

• Knowledgeable in enterprise data warehousing and dimensional modeling, covering fact and dimension design.

• Proven experience in defining enterprise KPIs, business rules, and governed data products.

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

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

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

• Practical knowledge of Azure, Databricks, or comparable cloud data platforms.

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

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

• Strong background in writing and optimizing complex SQL queries.

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

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

• Familiarity with Power BI semantic models and enterprise reporting.

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

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

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

• Familiarity with Azure Data Lake, Azure Data Factory, Databricks, or Unity Catalog is a plus.

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

• Experience in defining enterprise data products utilized by APIs and AI applications is a plus.

• Experience in managing enterprise KPI catalogs, metadata repositories, and data lineage is a plus.

🏝️ Benefits

• Competitive salary and performance-based incentives.

• Comprehensive health and wellness benefits.

• Opportunities for professional development and career growth.

• Flexible work arrangements and a supportive team environment.