Technical Analyst

Blackboard; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

A leading company focused on innovation in education technology seeks a Technical Analyst to develop and maintain ETL processes essential for data migration. The ideal candidate will possess a strong background in SQL Server, ETL, and effective communication across technical and non-technical teams. This role promises a dynamic work environment as part of a diverse and inclusive workforce committed to student growth and institutional success.

Qualifications

• Bachelor's degree, preferably in computer science or related field.
• 5-8 years of ERP experience is required.
• Fluency in written and spoken English at CEF B2 level or above.

Responsibilities

• Develop and maintain ETL processes in support of data migration efforts.
• Collaborate with stakeholders to understand business requirements.
• Manage all aspects of data architecture including models and ETL framework.

Skills

SQL Server 2019

ETL processes

Performance tuning

Data governance

Education

Bachelor's degree in computer science or related field

Tools

Microsoft BI Stack (SSRS, SSIS, SSAS)

Azure SQL

Azure Data Factory

Job description

Description

Technical Analyst Remote - Colombia *ONLY CVs SUBMITTED IN ENGLISH WILL BE CONSIDERED* 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 Technical Analyst 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

The Candidate: Required skills/qualifications:

• Bachelor's degree, preferably in computer science, computer programming or related field
• 5-8 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 at CEF B2 level or above

Preferred skills/qualifications:

• 2 or more years SIS higher education experienc
• e 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

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.