Consultant Data Developer (ETL) Job at Artic Consulting, Redmond, WA

cFlJb2dFT2ovOUJOTlpQNEdRMWhHd3Ny
  • Artic Consulting
  • Redmond, WA

Job Description

Job Summary: 

Artic Consulting Pvt Ltd is seeking a skilled Data Developer (ETL) – Sr. Consultant to design, develop, and optimize ETL pipelines for large-scale data transformations. The role involves troubleshooting ETL failures, validating SQL queries, and ensuring data accuracy. The ideal candidate should have experience with Microsoft SQL Server, SSIS, and stored procedures, along with a strong understanding of data warehousing concepts. 

Key Responsibilities: 

  • Validate and optimize SQL queries for accuracy, efficiency, and performance.  
  • Maintain and support the Generate system, ensuring its stability, performance, and security 
  • Develop and optimize ETL pipelines to extract, transform, and load (ETL) data from state education systems, Generate into Azure SQL and SQL Server on perm. 
  • Troubleshoot ETL failures and resolve data integrity issues while optimizing system performance. 
  • Prepare and validate data for federal ED Facts reporting. 
  • Develop and document business rules for data processing and reporting. 
  • Ensure compliance with Common Education Data Standards (CEDS) for the state of Washington. 
  • Collaborate with stakeholders to define data requirements and reporting standards. 
  • Support Agile development practices, including participation in Scrum sprint planning and retrospectives. 

Required Skills & Qualifications:  

  • 3+ years of experience in ETL processes, data management, and system maintenance. 
  • Hands-on experience with Microsoft SQL Server, SSIS, and stored procedures. 
  • Strong understanding of data warehousing concepts and relational database design. 
  • Ability to troubleshoot ETL failures and data integrity issues. 
  • Excellent SQL query validation and optimization skills. 
  • Strong technical documentation and analytical skills. 
  • Experience in working with federal and state educational data systems is a plus 

Preferred Qualifications:  

  • Experience with Generate and federal ED Facts reporting. 
  • Knowledge of Common Education Data Standards (CEDS). 
  • Exposure to cloud-based data solutions (Azure, AWS, etc.) is an advantage.  
  • Prior consulting experience is strongly preferred 
  • If you are passionate about data and have a keen eye for optimizing ETL processes, we’d love to hear from you! 

Equal Employment Opportunity

Artic Consulting is an EEO and Affirmative Action Employer of Females/Minorities/Veterans/Individuals with Disabilities.  
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.  
Artic is committed to providing veteran employment opportunities to our service men and women.  
Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring.  

Benefits  

Join Artic and you will benefit from outstanding professional support and investment in your development.  You will have the opportunity to learn from and be coached by the best in the business – supportive leaders and colleagues who can pass on their industry, technical and functional expertise.   

This also includes medical, dental, vision, and life insurance benefits, 401k, vacation, and annual review process.  

Job Tags

Permanent employment, Full time, Local area,

Similar Jobs

Scheels

PT Early Morning Facilities / Cleaning Associate Job at Scheels

 ...Compensation/Scheduling Compensation $15.00 hourly DOE. Early morning availability required (6:00 am to 11:00 am) (to include two weekends...  ...duties to include, but not limited to, vacuuming, mopping, cleaning and emptying waste baskets Answering calls from leadership... 

Dare Commercial Services

Outdoor Janitorial Job at Dare Commercial Services

 ...clean. We are hiring Full time and Part Time. Perfect for semi-retired person looking for exercise! Salary: Starting rate $17.00/hour...  ...valid driver's license AND reliable transportation to get to work. We provide vehicles during working hours. Must live within 3... 

Nachhilfeunterricht

Remote Work from home as an private online English Tutor - Part Time Job at Nachhilfeunterricht

 ...this is your chance to start working with your first students today. Flexibility of timetable Possibility of teleworking / remote work You will be able to set the price of your classes OFFER DETAILS Flexible timetable Remuneration between 2... 

HCA Healthcare

Surgery Scheduler Job at HCA Healthcare

 ...Healthcare, we are committed to caring for patients with purpose and integrity. We care like family! Jump-start your career as a Surgery Scheduler today with Careos Surgicenter.**Benefits**Careos Surgicenter offers a total rewards package that supports the health, life,... 

PlanITROI, LLC

Tier 3 Computer Repair Lead Technician Job at PlanITROI, LLC

 ...and data security while changing lives with their retired computing devices. PlanITROI leverages the circular economy to do social...  ...Overview: PlanITROI is seeking skilled Tier 3 Computer Repair Lead Technicians to join our IT Asset Disposition (ITAD) refurbishing team....