Responsibilities/Expectations:
• Works with large data sets in a hybrid cloud environment to develop descriptive statistical models to solve business problems
• Supports full life cycle of developed solutions and data warehouses including managing changes, production support, server/cloud optimization, and continual solution improvement
• Works with individuals at all levels of the organization to understand business needs and challenges, and recommends and implements improvements as well as solves problems with existing solutions when incidents occur
• Develops, builds, and maintains the company Business Intelligence infrastructure and data warehouse • Solves problems within SSIS, Azure Data Factory, and SSRS failures and defects and resolves issues timely • Collaborates across the enterprise to understand needs of the business and skillsets of citizen develops in order to continually improve business practices, architecture, data availability, and application support
• Develops and delivers training and contributes to policies and procedures to support citizen development efforts
• Other duties as assigned
Education/Years of Experience:
• Required: Bachelor's degree in information technology, engineering, business, or a related field and a minimum of five (5) years' experience including one (1) year supporting a major technology application
• Preferred: A minimum of seven (7) years' experience with five (5) or more years in data science and/or business intelligence development
Other Requirements:
• Demonstrates excellent organizational/interpersonal skills and safety as the utmost priority
• Needs basic knowledge of Microsoft Office Application and PC skills
• Proficiency in Database (SQL, Oracle)
• Solid understanding of data warehousing (SQL, Synapse)
• Solid understanding of ETL and Job Management • Solid understanding of BI development and associated reports and dashboards (Power BI) • Solid understanding of OLAP/CUBE design • Solid understanding of multi-dimensional database structures (e.g. star schemas) • Preferred: Proficiency in Azure analytics platform (e.g. synapse, data bricks, data factory)
• Preferred: Microsoft certified – Azure Fundamentals
• Preferred: Microsoft certified – Azure Data Fundamentals
