Job Description
Sound Transit IT Temporary Contractor Request Form ssignment: ETL Developer / Data Engineer
Category/Level*: G/ Level 2
Term of Assignment: 1/2/2024 - 12/01/2024 (11 months)
Date Candidate Resumes due to Sound Transit: 12/18/2023
Rate Range: Minimum to midpoint
General Summary: Seeking a highly skilled ETL Developer / Data Engineer who will be responsible for developing ETL solutions using Microsoft SQL Server Integration Services (SSIS). This role requires experience in designing data pipelines, SQL programming, stored procedures, data modeling, ETL, API Integration, and PowerBI Dashboards.
Essential Functions: • Design, develop, and maintain SQL Server Integration Services (SSIS) packages to facilitate efficient data extraction from disparate data sources including Rest APIs, transformation, and loading (ETL) processes.
• Create and optimize complex SQL queries, stored procedures, and functions to extract, transform, and load data from various data sources including API integrations.
• Perform data profiling and analysis to identify data quality issues and propose appropriate solutions.
• Implement data cleansing, transformation, and validation rules to ensure the accuracy and consistency of data.
• Collaborate with data engineers, database administrators, and enterprise architects to design and maintain data models and database schemas.
• Create/Maintain design related artifacts including data models, mapping documents, architecture diagrams, data flow diagrams, data dictionaries, and technical specifications.
• Monitor and optimize the performance of SQL queries, ETL processes, and Database objects (tables, views, indexes) to ensure efficient data processing and system reliability.
• Troubleshoot, Monitor, Notify, and Resolve data-related issues, including data integration failures, data quality problems, and performance bottlenecks.
• Monitor daily ETL jobs and data loads and proactively resolve issues to ensure maximum uptime/availability of data for reporting.
• Test and prepare ETL processes for deployment to production and non-production environments.
• Support system and acceptance testing including the development or refinement of test plans.
Deliverables: • ETL Pipelines (Code/configuration)
• SSIS Packages
• PowerBI Dashboards
• Documentation
Special / Additional Qualifications (Over Role/ Category Level) Education & Experience: Experience in designing and implementing SSIS solutions according to best practices including design, configuration, data mapping, data quality, extraction, transformation, and loading.
Required Licenses or Certifications: None
Specific Qualifications, Knowledge, and Skills:
• In-depth knowledge of Microsoft SQL Server Integration Services (SSIS) and experience in designing and developing ETL processes including extracting data from API(s).
• Proficiency in SQL programming, including complex query optimization, stored procedures, views, and functions.
• Solid understanding of data modeling concepts and experience in designing and implementing database schemas.
• Familiarity with creating data quality checks on ETL.
• Strong problem-solving and analytical skills with the ability to identify data-related issues and propose effective solutions.
• Experience with performance tuning and optimization of SQL queries, ETL processes, and database systems.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
Physical Demands/Work Environment: • Work will be performed in vi remote office. Sound Transit promotes a safe and healthy work environment and provides appropriate safety and equipment training for all personnel as required.
It is the responsibility of all employees and temporary staff to follow the Agency safety rules, regulations, and procedures pertaining to their assigned duties and responsibilities, which could include systems, operations, and/or other employees.
Job Tags
Temporary work, For contractors, Work at office, Remote work,