Assistant Director, Enterprise Data & BI

Do you have a passion for children and education? Would you like to positively impact families in need of help? We want to speak with you!

Step Up For Students empowers families to pursue and engage in the most appropriate learning options for their children.

Step Up For Students offers an excellent benefits package:

SUFS Total Rewards

Medical - HSA/FSA - Dental - Vision
Company Paid Disability - Life Insurance
401K Match - Tuition Reimbursement
Generous Time off Policy - Professional Development


JOB SUMMARY
Responsible for the management and direction of the design, development, deployment and support of Business Intelligent and Data Systems used enterprise wide for data storage and analysis. He/she directs and contributes to the modification of software and data applications or architecture to resolve issues and support future growth.

The Assistant Director, Business Intelligence and Data is also responsible management of the installation, maintenance and upgrades for databases utilized for commercial off the shelf (COTS) and custom software applications managed by the IT department. This hands-on position requires high levels of attention to detail to ensure that systems needed by the organizations are fully functional and operating 24 x 7 x 365. This position will report to the Senior Director, Software and Quality Engineering.

KEY RESPONSIBILITIES
◦ Leads the effort for the development of Business Intelligence solutions using tools from the Microsoft data suite stack including SSRS, SSIS, SSAS, and T-SQL stored procedures as well as MDX and Power BI.
◦ Directs the installation, configuration and administration of SQL Server database systems utilizing database replication, Always-On availability groups and automated failover.
◦ Proactively monitors, tunes and maintains databases from performance, capacity management and business continuity perspectives.
◦ Develops, tests, documents and implements high-performing, scalable solutions including schema design, storage engines, indexing strategies, SQL tuning, ETL processes, stored procedures and software applications.
◦ Develops multi-year strategies, roadmaps and plans for enterprise data information architecture to include migration to an HA/DR posture within the cloud.
◦ Participates in the definition of technical standards and guidelines that pertain to data systems and information use, security, access, and governance.
◦ Researches and evaluates new data system technologies for use within the enterprise and implement based on best practices to provide a reduction in maintenance and development overhead.
◦ Develops and manages effective working relationships with other departments, groups or personnel with whom work must be coordinated.
◦ Manages, directs and supervises assigned direct reports, including general leadership, planning, organizing, and reviewing performance.
◦ Serves as a coach and mentor to team members. Delegate tasks as appropriate.
◦ Manages troubleshooting and resolution of data support issues.
◦ Establishes and participates in rotating on-call schedule for 24 x 7 x 365 support.

EDUCATION & EXPERIENCE
REQUIRED:
◦ Demonstrated success and a proven track record of professional/life experience in specific job functions, projects, industries or military service can substitute for professional experience and/or formal education requirements.
◦ Bachelor’s degree in Computer Science or Information Systems or Associate Degree and two years of work experience OR an equivalent combination of education and experience.
◦ Minimum of five years administering enterprise-wide database systems.
◦ Minimum of seven years of experience with MS-SQL writing stored procedures and database scheme design.
◦ Minimum of five years of experience with database administration including performance tuning, monitoring, high availability/ disaster recovery.
◦ Minimum of five years of experience with database reporting and analytics using Reporting Services, Integration Services, and Analysis services.
◦ Minimum of seven years of experience with Microsoft operating systems.

KEY COMPETENCIES
◦ Possesses an understanding of information systems, data modeling, business intelligence, relational database design and knowledge of how to access multiple information sources for analytical purposes.
◦ Experience in developing ETL solutions for data warehouse loads and system integrations using SSIS Packages.
◦ Deep understanding of Data System Architecture and server based programming or scripting languages such as C# or PowerShell.
◦ Ability to establish rapport and drive consensus and change at all levels of the organization.
CORE VALUES
Step Up For Students believes strongly in two key core values t