Data Analytics Analyst III 4P/650

We are seeking an experienced Data Analytics Analyst III with strong expertise in data modeling, Power BI, SQL, and Azure-based analytics environments.

This role blends advanced analytics, BI development, and cloud-based data preparation within a modern lakehouse architecture (Databricks / Delta Lake). The ideal candidate can translate business questions into structured analytical datasets and actionable dashboards while coordinating small-to-mid-sized analytics workstreams., Data Modeling & Architecture

• Design and implement dimensional and relational data models:
• Star schema
• Conceptual, logical, and physical models
• Enterprise data structures
• Apply best practices for performance optimization and scalability.

SQL & Data Engineering

• Develop advanced SQL queries across relational databases:
• Azure SQL
• SQL Server
• PostgreSQL
• Work within Databricks and Delta Lake notebook environments.
• Support ETL/ELT processes, data validation, and data performance tuning.

Business Intelligence & Reporting

• Develop and maintain enterprise dashboards using Power BI.
• Create semantic models using:
• DAX
• Power Query (M)
• Apply visualization best practices and dashboard UI/UX standards.
• Translate business requirements into analytical datasets and KPIs.

Data Preparation & Cloud Analytics

• Work within Azure analytics ecosystems:
• Azure Data Factory
• Azure Synapse
• Microsoft Fabric
• Utilize Databricks SQL or Spark SQL for advanced analytical queries.

Project & Stakeholder Coordination

• Coordinate small to mid-sized analytics projects or workstreams.
• Partner with business stakeholders to clarify requirements.
• Provide data-driven insights to support strategic decisions.

Data Analysis, Analysis Skills, United States Citizen, Data Analysis, Analysis Skills, Data Modeling, Power BI, SQL (Structured Query Language), Microsoft Windows Azure, Business Intelligence, * 5-10 years of experience in data analytics or BI roles.

• Strong experience with:
• Data modeling (dimensional/star schema)
• SQL and relational databases
• Power BI (DAX, Power Query, dataset modeling)
• Hands-on experience with:
• Databricks
• Delta Lake
• Notebook-based development
• Strong Excel skills:
• Power Query
• Power Pivot
• Advanced formulas
• Ability to convert business questions into structured analytical outputs., * Experience with:
• Power Apps
• Power Automate
• Exposure to Azure analytics tools (ADF, Synapse, Fabric).
• Experience with Python or R for data transformation.
• Knowledge of:
• Data governance
• Metadata management
• Data stewardship
• Familiarity with Spark SQL or Databricks SQL., * SQL (Azure SQL / SQL Server / PostgreSQL)
• Power BI (DAX / M / Semantic Modeling)
• Databricks / Delta Lake
• Data Modeling (Star Schema / Lakehouse)
• ETL / ELT Concepts
• Excel (Advanced)
• Azure Cloud Analytics
• Spark SQL (Preferred)

Core Competencies

• Strong analytical and critical thinking skills
• Business translation capability (technical business)
• Attention to data quality and validation
• Project coordination and stakeholder management
• Ability to work in cloud-based, modern data ecosystems