Job Description

Job Title: Sr. ETL Developer


Location: Remote



Responsibilities:
• Maintain and Manage the existing 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.
• Create REST API integrations with vendors and Partners
• 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 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 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 API development experience
• Experience with C#, Python, JavaScript
• Understanding of and RESTful design
• Knowledge of JSON and XMS
• Experience with SQL Server 2012/2019
• Ability to develop and organize high-quality documentation
• Experience with at least one job scheduler
• Experience with the client or large school district
• Experience with compliance reporting (State and DOE)
• Knowledge of Aspen SIS database
• Experience OneRoster 1.1 or later
• Knowledge of the client Selective Enrollment process
• Knowledge of SalesForceBULK API desirable
• Knowledge of ISBE WCF SOAP Protocol desirable

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

Job Tags

Remote job,

Similar Jobs