Data Analyst- JD
Responsibilities:
- Receive direction from the Product Owner for data analysis objectives and tasks (story level)
- Collaborating with data architects, data engineers, and business users to develop the desired Microsoft Power BI solutions
- Collaborate and receive rules and requirements from business, functional, or application SMEs to inform analysis tasks.
- Analyze datasets, entities, application and system of record data sources, define relationships and attributes, and determine source to target mapping requirements
- Clean and validate data to ensure accuracy and quality prior to maturing the feature to build
- Define data engineering requirements for pipeline and data products build
- Spike with other IT professionals to define interface requirements between applications or systems within the Client portfolio or externally with vendors’ apps
- Occasional collaboration with the Enterprise Data Architects and the Surface Platform Architects to develop and refine the Data Models as part of the Client Enterprise Data Model
- Initial QC and validation of produced data products before delivering to stakeholders
Required Technical Skills
- Awareness of the upstream business domain and processes
- Strong data-level analytical skills
- Expert-level PowerBI skills, including developing data flows, semantic models (data sets), and visualizations
- Strong interpersonal skills working within a team
- Proficient interpersonal skills working external to the immediate team (i.e. system of record SMEs or admins, functional SMEs, vendor SMEs)
- Proficient SQL skills to build queries
Preferred Requirements
- Basic or awareness of data modeling and approaches
- Experience with cloud services such as ADLS gen 2, Databricks, Synapse, Azure SQL
- Basic or awareness of knowledge of the Client Enterprise Data Model
- ERP system experience (e.g. SAP S/4HANA, JDE)
- Product allocation experience (e.g. Energy Components)
- Awareness of Client standards such as WRO, FIRM and PSRI
- “PL-300 (Microsoft Power BI Data Analyst) or DP-500 (Azure Enterprise Data Analyst) certification or plans to achieve in near future