Vacancy expired!
Our client needs a Data Analyst who, through research and analysis of data from different functional systems, will develop data integration/aggregation solutions to support data analytics and visualization tools. The ideal candidate will partner with executive stakeholders, finance/operations/sales subject matter experts and functional leaders in creating robust and scalable data analytics solutions for business insight. The data analyst must possess a collaborative attitude, strong oral/written presentation skills, excellent problem-solving skills, and solid analytical/critical thinking skills.
Essential Duties:- Design and implement a flexible data access platform for operational data stores/islands, data warehouses, data marts and data lakes using standard practices as well as documenting the systems of record, data dictionaries and data flow diagrams for strategic data management
- Using logical data models, help build data marts for analysis to determine trends and significant data relationships across different functional areas
- Translate business needs into data modeling and reporting initiatives
- Work with business stakeholders to interpret data to identify trends to go across future data sets
- Adapt standard or develop novel applications of classification, forecasting, simulation, optimization, and summarization techniques
- Create compelling interactive visualizations and presentations to enhance decision making capabilities throughout the company
- Develop extracts, transforms, and loads with SQL
- Drive AWS/Azure cloud data platform architectural decisions and development standards
- Actively contribute towards data migration tasks from on-premises to cloud
- Multi-task across several ongoing projects and daily duties of varying priorities as required
- Ability to make good judgments, decisions, negotiate and drive problem resolutions
- Create detailed technical specifications and release documentation for assigned ETL and reporting projects
- Experience with Data Warehousing methodologies and concepts
- Experience working with large data sets.
- Expert knowledge of analytical tools and scripting languages
- Extensive experience with BI/DW lifecycle including source data analysis, ETL, data marts, reporting, dashboards, and analytics
- 8+ years of experience working with MS SQL Server database. Mastery of SQL, specifically MS SQL Server 2012 and higher.
- 8+ years of experience developing ETL processes with large scale data warehouses required
- 2+ years working in DevOps, automating, and deploying packages between different environments
- 5+ years working in Alteryx, Power BI
- High proficiency in dimensional modeling techniques and their applications including star schemas
- Familiarity with Data Governance and Master Data Management principles
- Ability to work with structured and unstructured source data
Vacancy expired!