Job Description
The Data Analyst is responsible for understanding business requirements and designing data models to transform raw data into meaningful insights. They will be responsible for designing data pipelines and infrastructure, developing reports and dashboards, interpreting data, and communicating to technical and non-technical audiences. The individual in this role must be analytical and resourceful, have excellent communication skills, and can work directly with end users and stakeholders.
ESSENTIAL JOB FUNCTIONS:
- Develops professional-quality business intelligence, data visualization, and analytics content in support of OSIS’s strategic priorities, using Power BI and Crystal Reports.
- Provide Subject Matter Expertise (SME) support in common functions of the BI technologies including reporting, analytics, analytical processing, data transformation, and data.
- Identify, design, and implement internal process improvements, such as automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Optimizes performance and usability of Power BI reports and dashboards by tuning queries, implementing efficient data models, and applying best practices.
- Collaborates with business stakeholders to understand their requirements, translates them into technical specifications, and designs efficient and visually appealing Power BI reports and dashboards.
- Provides a high level of internal and external customer service.
REQUIRED EDUCATION AND EXPERIENCE:
- BS degree in Computer Science or Computer Engineering, or equivalent experience
- Minimum 2 years of demonstrated experience developing accurate, effective, and appealing visualizations using Microsoft Power BI.
- Knowledge of Power BI application security layer models
- Proficient in SQL, T-SQL, and SQL Server Management Studio
- Strong Knowledge of DW architecture and ETL frameworks
- Understand relational Database concepts, including normalization and query optimization
PREFERRED EXPERIENCE:
- Experience using Azure Data Factory (ADF), building and managing data pipelines to enable the flow of data into an Azure-based Enterprise Data Platform
- Experience developing reports with Crystal Reports
- Familiar with Azure DevOps, Agile development, and Git
TELECOMMUTING AND TECHNICAL REQUIREMENTS:
This position is a remote role.
Must have:
- Cable or Fiber Internet Service
- Download speed of 20Mbps or higher
- Upload speed of 5Mbps or higher