Qualifications

This person must have a strong understanding of moving from traditional reporting tools to advanced capabilities in Azure

Strong knowledge and deep understanding of cloud computing and Microsoft Azure services like Azure SQL DW, Azure SQL DB Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, and other services

Expertise with T-SQL - queries, stored procedures, functions, views, constraints

2 years experience with writing, testing, and debugging programs

This position requires use of information which is subject to the International Traffic in Arms Regulations (ITAR) and the Export Administration Regulations (EAR)

All applicants must be U.S. persons within the meaning of ITAR and EAR or possess all required authorizations from the U.S

Responsibilities

Plans, designs, and develops Power BI and Data Warehouse solutions in Azure Synapse that enhance analytics and reporting capabilities as the company transitions to a cloud strategy for analytics and reporting

This individual will be a key contributor in the migration of analytics and reporting to the Azure cloud

Designs, develops, and maintains enterprise data warehouse; integrates BI solutions within enterprise data warehouse

Follows best practices in data modeling and source-to-target mapping

Internal subject matter expert on IT solutions; develops, designs, and maintains enterprise data warehouse

Follows best practices and guidelines to support best-of-breed dashboards, metrics, scorecards, and reporting solutions providing a high level of customer service to internal clients with an emphasis on partnership and collaboration

Implements and supports data warehouse architecture

Utilizes sound development life cycle practices, adheres to established processes, and documents delivery of application solutions (including business analysis, design, testing, implementation, support, and decommissioning)

Performs changes according to process, teamwork, and best practices for IT Change Management

Documents change, facilitates architecture review, plans and schedules change, coordinates with stakeholders, conducts testing, ensures training needs are addressed, and plans for roll-back in the event that roll-back is needed

Performs planned maintenance (e.g., application upgrades, releases, enhancements, service packs, etc.) on BI solutions and underlying infrastructure

Supports BI solutions; performs triage on incidents, troubleshoots issues, and resolves incidents while communicating with stakeholders

Ensures that adequate security procedures are developed and followed, to protect the company from potential loss and ensures the confidentiality of the information is maintained by the system

Contributes technical knowledge and understanding of applications to training programs, support processes, and operating procedures

Benefits

All members included in cash bonus opportunity

9.5% annual retirement benefit opportunity

Tuition reimbursement and Training/Professional Development opportunities for all members

12 paid holidays, including floating holidays

Industry leading medical, dental, and vision Insurance upon date of hire

Vacation / Sick Time / Vacation Buy-up / Short Term Disability / Bereavement leave

Paid parental leave

Employee Assistance Program, including mental health benefits

Spouse / Child Optional Life / Optional AD&D / Healthcare and Dependent Care Flexible Spending

Home / Auto Insurance discounts

Whole Life Insurance / Critical Illness Insurance / Legal Assistance / Military Leave