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

Sorrel River Ranch

Spa Therapist Job at Sorrel River Ranch

 ...organized spa environment through consistent monitoring of the entire Spa. Make sure the Spa is always guest-facing. The spa therapist must act as a role model, demonstrating the high standards of guest service and treatment protocol. Ensure knowledge of all spa... 

TheRapidHire Private Limited

Java Developer Job at TheRapidHire Private Limited

# Design, develop, and maintain Java-based applications and web services. # Write clean, scalable, and reusable code following best practices. # Integrate APIs, databases, and third-party systems. # Collaborate with front-end developers, testers, and product teams... 

Beijing Lan Xiaoyu Information Consulting Center

actor/model Job at Beijing Lan Xiaoyu Information Consulting Center

Job Responsibilities:1. Perform in short play performances as required;2. Complete assigned acting tasks with a certain level of expressiveness;

Liberty Personnel Services, Inc.

Fabrication Project Manager Job at Liberty Personnel Services, Inc.

 ...Job Details: Miscellaneous Steel Project Manager | Greater Washington, DC Region Commercial & Industrial Projects | $100,000$130,0...  ...architectural metalsplus strong communication, scheduling, and contract management skills. Kindly send resume to rick@... 

Dartmouth Health

Managing Editor - Journal - SYNERGY Job at Dartmouth Health

 ...responsible for leading the day-to-day operations of theDartmouth Journal of Healthcare Delivery Science.* This includes ensuring that...  ...along with co-workers.* Copyediting experience desirable.* Remote:Hybrid Remote* Area of Interest:Professional/Management* FTE/...