Data Warehouse Manager/Business Intelligence Developer

  • Cadence Education
  • 7135 E Camelback Rd #230, Scottsdale, AZ 85251, USA
  • Nov 09, 2020
[Information Technology]

Job Description

Data Warehouse Manager/Business Intelligence DeveloperScottsdale, AZCadence Education is currently seeking a MS SQL Developer who has also has experience performing some DBA functions described below.Candidate will be responsible for the development and administration of various SQL Server based systems in an Azure Data Warehouse environment supporting BI applications such as Power BI. This hands-on position requires solid technical and analytical skills, as well as excellent interpersonal and communication skills. The ideal candidate will be able to contribute to a wide variety of data-centric requirements. Must be a self-starter who enjoys problem solving researching techniques and methodologies to produce effective, complete, and reliable solutions. Ability to collaborate and work with teams and can be counted on to complete assignments in a timely manner with minimal oversight.Job Title Required Skills and Education:+ SQL Developer: 4 years+ SQL DBA: 4 years+ 5 + years working knowledge of Microsoft SQL Server 2008R2 or newer versions+ Experience implementing maintaining and automating backup and recovery plans.+ Experience in database design, development, implementation and methodologies for Data warehouses and OLTP business systems.+ Comprehensive knowledge of Transact SQL, Stored procedures, Views, Triggers, Functions.+ Experience automating data Import/Extraction using SQL Server tools such as SSIS, BCP, bulk insert.+ Ability to examine and optimize query execution plans and index/data usage.+ Experience analyzing hardware, software, network ecosystems to optimize database server performance.+ Experience resolving locking, dead lock issues.+ Experience with Microsoft Reporting and Analysis Services.+ .Net and Java+ Ability to work with internal teams, including the ability to read and interpret what the internal team is saying to proactively identify potential issues and problems and advise the internal teams on best practices and/or be able to suggest and deliver product enhancements+ Excellent oral and written communications skillsJob Title Job Responsibilities: Develop and maintain ETL processes to support: data warehouse, business intelligence, internal and external data integration needs. Development of SQL procedures, triggers, views, functions to support enhancement to critical SQL based business systems. Analyze troubleshoot and remediate data integrity issues. Monitor systems; proactively manage and maintain configurations to insure performance and availability. Perform database and related asset backups and recovery. SQL query optimization; index management. System performance and optimization tuning. Support production systems for database problem resolution, recovery and Emergency off-hour support.Cadence Education is one of the premier early childhood educators in the United States, operating over 225 private preschools and elementary schools across 27 states. With over 27 years in business, we have developed an unparalleled expertise in preparing students to thrive in the next step of their childhood.Our overall mission is to provide parents with peace of mind by giving children an exceptional education every fun-filled day in a place as nurturing as home. This mission can only be accomplished through a team of passionate childcare professionals who combine their talents to provide an unparalleled level of care and compassion for children and their families. Our research-based curriculum and home-based environments are anything but a daycare we are the evolution of early education.Our schools are staffed with individuals who are talented, fun, and genuinely enthusiastic about child development and learning. We encourage collaboration and cherish open-communication in each school and with our corporate office. We work hard to create an outstanding work-life balance by supporting leaders and staff members every step of the way. For additional information about Cadence, please visit of Working at Cadence Education:+ Competitive compensation+ 50% childcare tuition discount+ Educational and professional development+ Comprehensive benefit package for all full-time employees, including:+ Paid time off that increases with seniority+ Medical, dental, vision options available+ Additional life, disability, and retirement plans+ Tuition reimbursement+ Company-paid life insurance+ Paid holidaysSAFETY FIRST: The health and safety of every person in our schools is our primary concern and we are taking every precaution to prevent potential exposure or spread of COVID-19 within our schools. We are actively partnering with local health departments and closely following guidelines from the Centers for Disease Control and Prevention.Cadence Education is an Equal Opportunity Employer.School Name: 100 - School Support CenterRequisition ID: 2020-4998External Company URL: 8800 N Gainey Center Drive
Associated topics: chief program officer, cpo, manage, manager, management, monitor, product manager, project manager, relationship manager, task