Data Analyst, Enterprise Analytics Transformation

Data Analyst, Enterprise Analytics Transformation

Remote ( Once in while they might need to travel VA location and expenses are paid by the client)

This role is hands-on with data. The Data Analyst will work directly within the lakehouse environment to profile data, validate transformations, define metrics, and ensure analytics outputs are accurate, consistent, and aligned with business meaning.

This position sits at the intersection of business, data engineering, and technical architecture. The ideal candidate combines structured analytical thinking with practical technical skills and is comfortable working inside modern cloud data platforms.

Key Responsibilities

Data Understanding and Business Alignment

• Translate business questions and KPIs into structured data requirements
• Clarify metric definitions, assumptions, and calculation logic
• Work with stakeholders to ensure analytics outputs reflect intended business meaning
• Support prioritization of data and reporting needs

Lakehouse and Data Platform Work

• Work directly within Microsoft Fabric environments including lakehouse and warehouse layers
• Query and analyze data using SQL within Fabric
• Validate bronze, silver, and gold layer datasets
• Support semantic model validation and metric consistency
• Assist in defining data standards and reusable calculation logic

Data Quality, Profiling, and Migration

• Perform data profiling and exploratory analysis to identify anomalies and inconsistencies
• Validate completeness, accuracy, and reconciliation across systems
• Review transformation logic and mapping rules in collaboration with data engineers
• Document data lineage, business rules, and metric definitions
• Identify data quality gaps and support structured remediation

Analytics Validation and Enablement

• Translate requirements into reporting and analytics specifications
• Validate dashboards, KPIs, and calculated measures
• Participate in user acceptance testing and issue triage
• Support retirement of legacy reports and manual reconciliations
• Contribute to the continuous improvement of enterprise analytics assets

Required Qualifications

• 3 to 5 years of experience in data analysis within enterprise analytics or reporting environments
• Strong SQL skills and ability to query large datasets
• Experience working in modern cloud analytics platforms such as Microsoft Fabric, Azure Synapse, Databricks, Snowflake, or similar
• Understanding of lakehouse architecture concepts, including bronze, silver, and gold layers
• Familiarity with semantic modeling and BI tools such as Power BI or equivalent
• Experience with data profiling, reconciliation, and data quality validation

Preferred Qualifications

• Experience in regulated or multi-stakeholder environments
• Exposure to metadata, lineage, and governance concepts
• Familiarity with data transformation logic and basic scripting, such as Python or Spark
• Experience supporting large-scale data migration or modernization initiatives