Senior ETL Developer

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 the 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 within the 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.

Summarize your objectives for your contractors.

Efficient Data Integration - Create efficient Data Integration to integrate data from various sources that is accurate, reliable, and consistent.

Timely Delivery - Ensure data is delivered on time to downstream systems, vendors and partners and any delays are addressed promptly.

Data Quality - Data processed must be accurate, complete, and consistent.

Performance Optimization - ETL routines need to be optimized to ensure the nightly cycle completes and reports and dashboards should return data within five seconds.

Scalability - ETL processes should be built to scale as the volume of data increases over time.

Security - All code and processes developed must adhere to the district data security standards.

Transition to Full Time Employees - ETL routines and code developed should follow a standard framework to facilitate transition to the client Data Solutions team.

All new code and code changes should be documented following the established documentation standard.

Code development, testing and deployment - All production changes must follow the Change Advisory client process.

Codebase must be tracked and managed through the team’s code repository