Consultant Data Developer (ETL)
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.