Senior Azure BI Developer Location:Rockford, IL, USA
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 |