Senior ETL Developer

Job Description:

The Senior ETL Developer will be held accountable for the following responsibilities:

● Maintain and Manage the existing Client Enterprise Data Warehouse and ODS builds.
● Model extensions to the existing Data Warehouse
● Builds ETL components according to ETL specifications. Code must address performance, dependency, auditing, error handling and data quality issues.
● Support post deployment by debugging, fixing, and participating in maintenance.
● Create reports to meet business requirements and address data needs.
● Create Dashboard pages and metrics within Client custom dashboard solution.
● Responsible for data integrity as well as the quality of data within Dashboard presentation layer.
● Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot code-related issues; and review and provide feedback to the final user documentation.
● Read and understand business requirements, write functional requirements, develop detailed technical designs, and build / unit / system test ETL code.

In order to be successful and achieve the above responsibilities, the Senior Business Intelligence Analyst must possess the following qualifications:

Type of Education Required:

● Bachelor's Degree in Computer Science or related field

Type of Experience and Number of Years:

● 10+ years of Enterprise Data Warehouse experience.
● 5+ years of experience with an ETL product (SSIS, Ab Initio, etc.) in a development role (administrative knowledge a plus).
● Good knowledge of data modeling/Star Schema.
● Strong ANSI SQL expertise.
● REST APIs development experience.
● Experience with C#, Python, Java.
● 3+ years of experience with Unix and Shell Scripting.
● Experience with latest releases of SQL Server.
● Experience with Azure DevOps.
● Ability to develop and organize high-quality documentation.
● Experience with at least one job scheduler.
● Experience with Client or a large school district.

Knowledge, Skills, and Abilities:
● Strong written and oral communications skills.
● Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
● Strong systems/process orientation with demonstrated analytical thinking, organizational skills, and problem-solving skills.
● Ability to work in a team-oriented, collaborative environment.
● Ability to quickly pick up new tools and technologies.
● Willingness and ability to train and teach others.
● Ability to facilitate meetings and follow up with resulting action items.
● Ability to prioritize and execute tasks in a high-pressure environment.
● Strong presentation and interpersonal skills.
● Ability to effectively move forward on tasks even with ambiguous or changing requirements.