- 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.
- ETL Pipelines (Code/configuration)
- SSIS Packages
- PowerBI Dashboards
- Documentation
- 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.
- 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.
-
TS/SCI Data Integrator
3 weeks ago
Piper Companies Pasco, United StatesZachary Piper Solutions is seeking a Data Integrator to support a critical Intelligence program for DIA across various locations throughout the DMV. The team is seeking a skilled engineer to perform high volume data transfer and administration for an application development an ...
-
Cloud Solutions Architect
2 weeks ago
Ardent Services Pasco, United StatesWhy do you need to choose between doing important work and having a fulfilling life? At Ardent, we have both. Ardent employees are committed to solving our customers' most difficult problems-and we are committed to the well-being, personal goals, and professional development of o ...
-
Cloud Solutions Engineer
2 weeks ago
Ardent Services Pasco, United StatesWhy do you need to choose between doing important work and having a fulfilling life? At Ardent, we have both. Ardent employees are committed to solving our customers' most difficult problems-and we are committed to the well-being, personal goals, and professional development of o ...
-
Data Warehouse Developer II
2 weeks ago
MultiCare Health System, Inc. Pasco, United StatesYou Belong Here. · At MultiCare, we strive to offer a true sense of belonging for all our employees. Across our health care network, you will find a dynamic range of meaningful careers, opportunities for growth, safe workplaces, and flexible schedules. We are connected by our mi ...
-
Cloud Solutions Engineer
1 week ago
Ardent Services Pasco, United StatesWhy do you need to choose between doing important work and having a fulfilling life? · At Ardent , we have both. Ardent employees are committed to solving our customers' most difficult problems-and we are committed to the well-being, personal goals, and professional development ...
-
Cloud Solutions Engineer
2 weeks ago
Ardent Services Pasco, United StatesWhy do you need to choose between doing important work and having a fulfilling life? · At Ardent , we have both. Ardent employees are committed to solving our customers' most difficult problems-and we are committed to the well-being, personal goals, and professional development ...
-
Cloud Solutions Engineer
1 week ago
Ardent Services Pasco, United StatesWhy do you need to choose between doing important work and having a fulfilling life? At Ardent, we have both. Ardent employees are committed to solving our customers' most difficult problems-and we are committed to the well-being, personal goals, and professional development of o ...
-
Data Engineer II
3 weeks ago
Brooks Running Pasco, United StatesWho We Are: · At Brooks, we believe a run can change a day, a life, the world. Everyone who works here is a key part of our obsession to make the best running gear on the planet. We want our business - which also happens to be our passion - to be a place where everyone feels wel ...
-
Enterprise Data Engineer
4 weeks ago
Piper Companies Pasco, United StatesPiper Companies is seeking an · Enterprise Data Engineer · to join an environmental manufacturing organization based in · Washington, DC · . The · Enterprise Data Engineer · will own data conversion and system integrations for the implementation of Microsoft Dynamics 365 ac ...
-
Enterprise Data Engineer
3 weeks ago
Piper Companies Pasco, United StatesPiper Companies is looking for an Enterprise Data Engineer to join an environmental manufacturing organization based in Washington, DC . The Enterprise Data Engineer will own data conversion and system integrations for the implementation of Microsoft Dynamics 365 across multipl ...
-
Power BI Developer
2 weeks ago
TrueTandem Pasco, United StatesCompany Description · TrueTandem's mission is to be a trusted information technology solutions provider, committed to the success of our customers, communities and employees. To enable this mission, we listen to our customers' needs, empower our dedicated and talented employees, ...
-
Software Engineer
3 weeks ago
Branch Metrics Pasco, United StatesAt Branch, we're transforming how brands and users interact across digital platforms. Our mobile marketing and deep linking solutions are trusted to deliver seamless experiences that increase ROI, decrease wasted spend, and eliminate siloed attribution. Our Branch team consists o ...
-
Software Engineer
3 weeks ago
Branch Metrics Pasco, United StatesAt Branch, we're transforming how brands and users interact across digital platforms. Our mobile marketing and deep linking solutions are trusted to deliver seamless experiences that increase ROI, decrease wasted spend, and eliminate siloed attribution. Our Branch team consists o ...
-
Senior Analytics Engineer
3 weeks ago
Remitly Pasco, United States Full timeJob Description: · Remitly's vision is to transform lives with trusted financial services that transcend borders. Since 2011, we have been tirelessly delivering on our promises to people who send money around the world. Today, we are reimagining global financial services and bui ...
-
Junior Data Analyst
3 weeks ago
The Oakleaf Group Pasco, United States Full timeThe Oakleaf Group is a mortgage and financial services consulting firm with expertise in risk management and financial modeling for the mortgage and banking industries. Our clients are banks and non-bank mortgage firms, government agencies, law firms, insurance companies, institu ...
-
Mid Data Engineer
2 weeks ago
Prescient Edge Pasco, United StatesJob Title · Mid Data Engineer · Location · Washington, DC 20032 US (Primary) · Category · Research, Development, and Engineering · Job Type · Full-Time · Career Level · Staff · Education · Bachelor's Degree · Travel · None · Security Clearance Required · TS/SCI wit ...
-
Data Analyst
2 weeks ago
Significance Pasco, United StatesSignificance is a woman-owned consulting firm serving the federal government. We are known for building trusted relationships within our teams and with our clients and hiring the highest-level experts who implement innovative solutions. We also like to have fun Our focus on cultu ...
-
Software Engineer
1 week ago
Base2 Solutions Pasco, United StatesThis position is responsible for working with DoD, IC, and Federal customers to develop, deploy and configure data centric Zero Trust solutions. These solutions should adhere to Zero Trust best-practices, reference frameworks, regulations, and guidelines. Position requires interf ...
-
Principal Data Analyst
2 weeks ago
Remitly Pasco, United StatesJob Description: · Remitly's vision is to transform lives with trusted financial services that transcend borders. Since 2011, we have been tirelessly delivering on our promises to people who send money around the world. Today, we are reimagining global financial services and bui ...
-
Senior Data Scientist
1 week ago
National Association of Realtors Pasco, United StatesLocation: This position is located in the Chicago, IL or Washington, DC office only · Position Summary: · NAR's IT Data Science team is looking for a highly motivated senior Data Scientist to join our growing team and make their mark. We are currently on a transformation journe ...
ETL Developer - Pasco, United States - Abacus
Description
Sound Transit IT Temporary Contractor Request Form
ssignment:
ETL Developer / Data Engineer
Category/Level*:
G/ Level 2
Term of Assignment: 1/2/ /01/ 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:
Deliverables:
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:
Physical Demands/Work Environment:
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.
