Data Solutions Analyst - Enterprise Data - 1669
Onsite/ Hybrid/ Remote: Remote (EST only)
Duration: 6 months contract to hire
Rate Range: Up to $70/hr on C2C or $65/hr on 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
- 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.