Data Solutions Analyst – Enterprise Data

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

📋 Description

• Design and sustain Power BI reports and dashboards utilizing approved enterprise datasets and semantic models.

• Craft SQL queries to analyze data, explore discrepancies, verify results, and assist in business reporting.

• Collect and document business requirements, define KPIs, outline reporting needs, and establish acceptance criteria.

• Develop Power BI measures, visualizations, filters, and drill-through capabilities.

• Confirm reporting results against certified KPIs, source data, and business specifications.

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

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

• Identify and document data quality issues, such as duplicate records, missing identifiers, inconsistent values, and hierarchy discrepancies.

• Assist in master data management efforts, including data matching, standardization, and validation.

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

• Facilitate self-service reporting by guiding business users on approved datasets and reporting standards.

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

• Maintain documentation and promote continuous enhancement of data validation and reporting processes.

⛳️ Requirements

• Proficient SQL skills, encompassing joins, aggregations, filtering, data validation, and troubleshooting.

• Practical experience in developing Power BI reports and dashboards.

• Background in data profiling, reconciliation, QA, and report validation.

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

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

• Bachelor’s degree in Computer Science, Information Systems, Analytics, Mathematics, Finance, Business, or a related discipline, 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 in creating Power BI dashboards, reports, measures, filters, and drill-through capabilities.

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

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

• Ability to translate business reporting needs into technical specifications.

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

• 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 architectures.

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

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

🏝️ Benefits

• Comprehensive health, dental, and vision insurance.

• Retirement savings plan with company matching.

• Opportunities for professional development and growth.

• Flexible work schedule and remote work options.

• Generous paid time off and holiday leave.