Data solutions analyst - enterprise data - 1669

This is a remote position.

Onsite/ Hybrid/ Remote: Remote (EST only)

Duration: 6 months contract to hire

Rate Range: Up to $70 in C2C or 65 in W2

Work Authorization: GC, USC Only

Must Have:

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