Join National Heritage Academies (NHA) as a Data Warehouse ETL Developer. This position will report directly to the Director of Business Intelligence in the Information & Analystics department and will be the primary technical resource in developing and maintaining NHA's large and complex data warehouse solution.
NHA is a charter school management company that operates 80+ schools in 9 states. We are committed to our mission of "challenging each child to achieve..." and we pride ourselves on our students' ability to achieve high results in later education based on the foundations gained in grades K-8 at NHA.
In this role you will work out of our corporate headquarters (Service Center) located in Grand Rapids, Michigan. The NHA Service Center is where all the behind-the-scenes magic happens. Our 400 brilliant team members are brag-worthy. With a diverse group of departments like admissions, talent acquisition, facilities, legal services, and many more working together to provide top level back-office support. The Service Center is a place of bright colors, smiling faces, and opportunity. We like to gather for events such as the fall crocktoberfest cook-off, the sparkling holiday party full of fun and unexplainable excitement, and our annual 5K Service Center fun run.
Design and implement ETL (extract, transform, load) processes
Work with business owners to define project milestones and requirements
Perform data profiling and modeling
Create documentation of code, business processes, project requirements, etc
Perform user acceptance testing (UAT) to ensure data accuracy
Support, maintain, and monitor ETL processes
Resolve errors and data issues in a timely manner
Participate in required after-hours ETL monitoring rotation
Be self-directed and comfortable working independently
Bachelor's degree in an applicable field
Minimum of 1 year experience with SQL Server 2008, 2012, 2014, or 2016, or equivalent RDBMS software
Minimum of 1 year experience with SQL Server Integration Services (SSIS / SSDT) 2008, 2013, 2016 or equivalent ETL software
Strong SQL knowledge: ability to write highly efficient queriest, familiar with DDL, DML and TCL, and experience creating and modifying stores procedures, indexes, views and functions
Familiar with data warehousing concepts: database normalization, star vs. snowflake schema
Knowledge of dimensional modeling techniques - preferred
SQL server performance tuning and indexing experience; understands how to interpret execution plans - preferred
Knowledge of additional programming languages (C#, Python, etc.) - preferred
Experience processing various types of flat files: CSV, XML, and JSON - preferred
Experience using BIML (Business Intelligence Markup Language) - preferred
Experience working with Web Services and APIs - preferred
Excellent analytical problem solving and critical thinking skills
Innate desire to learn new skills and technologies
High degree of attention to detail and personal accountability
To learn more about our core values, please click here.
National Heritage Academies is an equal opportunity employer.
NHA, one of the nation’s leading charter school management organizations, currently operates more than 80 schools across nine states serving over 55,000 students in Kindergarten through 8th grade. Founded in 1995 and based in Grand Rapids, Michigan, NHA is a for-profit organization with nearly 5,000 employees.
NHA’s system of schools is designed to eliminate the achievement gap and provide a public school choice to families so their children are prepared for success in high school, college, and beyond. With a commitment to hard work, good citizenship, and personal responsibility, students experience a safe, secure learning environment where achievement thrives. A passion and dedication to the mission of serving children and partnering with communities to provide an excellent educational experience permeates the culture of our organization.