Description
ETL Developer
Remote - United States
The Opportunity:
Anthology delivers education and technology solutions so that students can reach their full potential and learning institutions thrive. Our mission is to empower educators and institutions with meaningful innovation that’s simple and intelligent, inspiring student success and institutional growth.
The Power of Together is built on having a diverse and inclusive workforce. We are committed to making diversity, inclusion, and belonging a foundational part of our hiring practices and who we are as a company.
For more information about Anthology and our career opportunities, please visit www.anthology.com.
The ETL Developer will develop and maintain ETL processes and tooling in support of Anthology system data migration efforts.
Specific responsibilities will include:
- Interfacing and working with business stakeholders to understand the business and functional requirements to develop ETL processes in support of system implementations
- Playing a leadership role in the design, implementation and development of ETL processes
- Managing all aspects of the data architecture, including models, data staging and ETL framework
- Collaborating with other cross-functional IT software/data personnel on development of EDW/database components
- Designing, developing, and maintaining solutions
- Interacting well with team members while maintaining multiple priorities in an extremely dynamic environment, initiating necessary tasks, and ensuring complete follow through
- Effectively multi-tasking with many projects consistently
- Owning quality and accountability of deliverables
The Candidate:
Required skills/qualifications:
- Bachelor's degree required, preferable in computer science, computer programming or related field.
- 2-5 years of ERP experience
- Solid knowledge of SQL Server 2019 with the development of complex stored procedures, views and other SQL objects
- Experience with performance tuning, code profiling, code review, hands-on experience using best practices
- Experience debugging and optimizing existing SQL scripts
- Experience identifying and documenting requirements through direct communication with the customer
- Strong oral and written communication skills and strong organizational skills
- Comfortable with direct communication with all levels of technical and business resources both internal and external
- Fluency in written and spoken English
Preferred skills/qualifications:
- 2 or more years of SIS higher education experience
- Microsoft BI Stack tools (SSRS, SSIS, SSAS)
- Background or familiarity with data governance, metadata management, taxonomy management, master data management and data security
- Experience with Azure SQL and Azure Data Factory
- Experience working with DevOps or other version control tools
- Experience completing enterprise data migrations/conversions from one system to another system as a part of the implementation
- Hands-on experience with relational and dimensional modeling practices
Pay range is $91,500 - $100,000/year depending upon experience. We use national and industry-specific survey data to assist in determining compensation. Additionally, we consider factors such as external market rate, budget for the role, and the compensation rates of current employees performing the same function. Some roles will have variable pay.
This job description is not designed to contain a comprehensive listing of activities, duties, or responsibilities that are required. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities at any time.
Anthology is an equal employment opportunity/affirmative action employer and considers qualified applicants for employment without regard to race, gender, age, color, religion, national origin, marital status, disability, sexual orientation, gender identity/expression, protected military/veteran status, or any other legally protected factor.
