GrandRapidsRecruiter Since 2001
the smart solution for Grand Rapids jobs

Data Warehouse - ETL Developer

Company: National Heritage Academies
Location: Grand Rapids
Posted on: September 13, 2019

Job Description:

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.

About Us

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.

Your Role

  • 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

    Requirements

    • 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 .

      National Heritage Academies is an equal opportunity employer.

Keywords: National Heritage Academies, Grand Rapids , Data Warehouse - ETL Developer, IT / Software / Systems , Grand Rapids, Michigan

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Junior Software Developer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze and build next-gen (more...)
Company: Revature
Location: South Bend
Posted on: 09/18/2019

Senior Full-Stack Software Engineer
Description: Let companies apply to you, not the other way around. Sign up with Hired to get access to thousands of companies currently hiring senior full-stack software engineers.Want to work for a company you love (more...)
Company: Hired
Location: South Bend
Posted on: 09/19/2019

Program Coordinator (PC)
Description: Sep 06 READ MORE Program Coordinator PC Location: South Bend, IN Wage: Sign-On Bonus: Category: Supported Living Description: Join Benchmark Human Services and positively impact the lives of other people (more...)
Company: Benchmark Human Services
Location: South Bend
Posted on: 09/19/2019


Sr. NET Developer
Description: As a Senior .NET Development Consultant, you will work closely with our clients and technical teams to solve technical challenges for our clients. The ideal candidate will combine technical and business (more...)
Company: Synkriom Inc
Location: Grand Rapids
Posted on: 09/19/2019

Senior Tableau Developer
Description: Duration: 3 years Rate: negotiable on w2/c2c/1099 Senior Tableau Developer The Senior Tableau Developer will manage all aspects of Tableau development while providing oversight of and guidance on data (more...)
Company: PMC
Location: Lansing
Posted on: 09/18/2019

Database Administrator 3
Description: Role: Database Administrator 3 Location: Lansing, MI 48933 Duration: 1 Year Need In-person Sep 23 26th Job Description: ul li Relies on experience and judgment to plan and accomplish goals, independently (more...)
Company: Qstride
Location: Lansing
Posted on: 09/18/2019

Infrastructure Solutions Architect 5 (606148)
Description: Title: DEQ/DNR/MDARD - Infrastructure Solutions Architect 5 606148 Location: Lansing MI Duration: Either Webcam or In Person Note : Face to Face Interviews preferred - interviews will take place 9/19 (more...)
Company: American Technology Consulting LLC
Location: Lansing
Posted on: 09/18/2019

SQL Server Database Administrator
Description: Direct Client Requirement Title: SQL Server Database Administrator Location: Lansing, MI Rate: DOE Duration: 12 Months Interview Type: In-Person only Work Status: Successful applicants must (more...)
Company: SohanIT INC
Location: Lansing
Posted on: 09/18/2019

Programmer 4
Description: You Can Reach me 845 267 1362 Desk -- 425 728 5136 Cell -- jobs avenuesinc.com Job Description: ul li This software developer position will be supporting the MDOT Development, Small New Technology, (more...)
Company: Avenues International, Inc.
Location: Lansing
Posted on: 09/18/2019

Back End Developer
Description: Back End Developer br If you are a Back End Developer with experience, please read on br Top Reasons to Work with Us br As one of the largest companies in the area we strive to innovate and stay (more...)
Company: CyberCoders
Location: Elkhart
Posted on: 09/18/2019

Log In or Create An Account

Get the latest Michigan jobs by following @recnetMI on Twitter!

Grand Rapids RSS job feeds