Data Solutions Analyst – Enterprise Data

Job Title:
Data Solutions Analyst – Enterprise Data

Location:
Remote / Home-Based, US Based

Duration: 6+ Months

Rate:
Open
- Keep Competitive

We are seeking a Data Solutions Analyst – Enterprise Data to support the development and adoption of client governed enterprise data products. Working under the direction of the Senior Data Solutions Analyst and in partnership with Azure Data Engineering and Business Intelligence teams, this role combines SQL-based data analysis, data validation, documentation, user acceptance testing, and Power BI report development. The successful candidate will use approved Gold Layer datasets and enterprise semantic models to create reliable reports, support certified KPI and master data initiatives, and help validate trusted data for reporting, analytics, and AI-enabled use cases.

• Support the Senior Data Solutions Analyst in gathering and documenting business requirements, KPI definitions, reporting needs, master data rules, and acceptance criteria.
• Write and validate SQL queries to profile data, investigate issues, reconcile results, and support approved metric logic.
• Build and maintain Power BI reports and dashboards using approved Gold Layer data and governed enterprise semantic models.
• Create report measures, visualizations, filters, drill paths, and user experiences within established semantic model and KPI standards.
• Validate Power BI report results against certified metrics, source data, and approved business requirements; identify and elevate inconsistencies.
• Perform data profiling, reconciliation, root-cause analysis, QA, regression testing, and UAT support across source systems and enterprise data products.
• Prepare and maintain test cases, reconciliation evidence, source-to-target mappings, report documentation, metric definitions, and business-to-technical mappings.
• Support client, product, vendor, consumer, and other master data initiatives by identifying duplicates, missing identifiers, hierarchy issues, conflicting values, and other data-quality exceptions.
• Test approved master data matching, standardization, hierarchy, crosswalk, and exception-handling rules and document results for review by senior team members and business data owners.
• Support controlled self-service reporting by helping users understand available Gold Layer data, certified KPIs, semantic models, and appropriate report-development practices.
• Assist with the preparation of governed datasets, definitions, metadata, and example questions used by Databricks Genie, copilots, and other approved AI-enabled analytics solutions.
• Test AI-generated analytical responses against certified metrics and approved reports, document inconsistencies, and elevate data or definition issues.
• Collaborate with Data Engineering and Business Intelligence teams to validate implemented solutions while following established standards for production support and access administration.
• Contribute to repeatable processes for report development, data validation, documentation, certification support, and issue tracking.

• 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, analytics, or a related role; relevant internship or project experience may be considered.
• Working SQL skills, including joins, aggregations, filtering, data-quality checks, and troubleshooting queries.
• Hands-on experience creating Power BI reports and dashboards, including visualizations, measures, filters, and drill-through behavior.
• Familiarity with Power BI semantic models, dimensional modeling, facts and dimensions,…