Sr. ETL Developer

Role: Sr. ETL DeveloperDuration: 6+ months Location: Remote

Project Description: The client seeks a senior skilled resource to support increased operational and project demand. The resource needs expertise in application and database development in addition to Education/school client or large school district knowledge. The consultant should be knowledgeable and skilled in Data Modeling, Database development, Dashboard, and Reports Development. Developing matching procedures. Application Development, Writing SQL scripts to extract data from the Aspen Student Information system. MS Power BI administration and development, Dashboard administration and development. REST APIs development experience. SSIS, Ab Initio, C#, Python. Database and ETL performance tuning and optimization. Compliance Reporting (State and DOF).

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.Qualifications:Type of Education Required:● Bachelor's Degree in Computer Science or related fieldType 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 Education client OR Schools Client or a large school districtKnowledge, 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

Key Skills

• Linux