Data Solutions Analyst - Enterprise Data

This is a remote position.

• Strong SQL skills, including joins, aggregations, filtering, data validation, and troubleshooting.
  

• Hands-on experience developing Power BI reports and dashboards.
  

• Experience with data profiling, reconciliation, QA, and report validation.
  

• Familiarity with Power BI semantic models, DAX, dimensional modeling, facts, dimensions, and relationships.
  

• Experience documenting business requirements, reporting logic, and data validation results.
  

Responsibilities:

• Develop and maintain Power BI reports and dashboards using approved enterprise datasets and semantic models.
  

• Write SQL queries to analyze data, investigate discrepancies, validate results, and support business reporting.
  

• Gather and document business requirements, KPI definitions, reporting needs, and acceptance criteria.
  

• Create Power BI measures, visualizations, filters, and drill-through functionality.
  

• Validate reporting results against certified KPIs, source data, and business requirements.
  

• Perform data profiling, reconciliation, root-cause analysis, regression testing, and UAT support.
  

• Prepare test cases, source-to-target mappings, reconciliation evidence, and technical documentation.
  

• Identify and document data-quality issues, including duplicate records, missing identifiers, inconsistent values, and hierarchy problems.
  

• Support master data management initiatives, including data matching, standardization, and validation.
  

• Work with Data Engineering and Business Intelligence teams to validate enterprise data solutions.
  

• Support self-service reporting by helping business users understand approved datasets and reporting standards.
  

• Assist in testing AI-generated analytical responses against validated business metrics and reports.
  

• Maintain documentation and support continuous improvement of data validation and reporting processes.
  

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Analytics, Mathematics, Finance, Business, or a related field, or equivalent practical experience.
  

• 1 to 3 years of experience in data analysis, business intelligence, reporting, or analytics. Relevant internship or project experience may be considered.
  

• Working knowledge of SQL for data analysis and troubleshooting.
  

• Experience creating Power BI dashboards, reports, measures, filters, and drill-through functionality.
  

• Understanding of data modeling, semantic models, and DAX concepts.
  

• Experience validating business reports, reconciling data, and documenting test results.
  

• Ability to translate business reporting requirements into technical specifications.
  

• Experience working with business stakeholders, analysts, BI developers, and data engineers.
  

Nice to Have:

• Exposure to Azure Data Lake, Azure Data Factory, Databricks, or Microsoft Fabric.
  

• Experience working with Gold Layer datasets and governed enterprise data products.
  

• Understanding of data governance, data quality, and master data management (MDM).
  

• Familiarity with certified KPIs, enterprise semantic models, and dimensional data structures.
  

• Exposure to Databricks Genie, AI copilots, or AI-assisted analytics.
  

• Experience supporting enterprise data certification and self-service BI reporting.