Lead Data Architecture Designer

Purpose of the Position:
The Lead Data Architecture Designer is responsible for designing, implementing, and managing the organization's data architecture. The role plays a critical role in migrating legacy systems to a modern technology stack, ensuring data integrity, security, and accessibility. The role works closely with cross-functional teams to understand business requirements and translate them into scalable and efficient data solutions. The role reports to the Director of Enterprise Data Architecture.

What You'll Do:

1. Lead Data Architecture Design and Implementation: Oversee data modeling, ETL processes, and data warehousing.
2. Migrate Legacy Systems:Transition from SQL Server-based data pipelines to Azure Data Factory, Azure Databricks, and Power BI.
3. Develop Data Integration Solutions:Create workflows and pipelines using Azure Data Factory and Databricks.
4. Support Advanced Analytics: Design and implement data solutions for business intelligence and advanced analytics.
5. Ensure Data Quality and Security: Collaborate with the data governance team to maintain data quality, consistency, and security.
6. Collaborate with Stakeholders: Understand and meet data requirements of business stakeholders.
7. Optimize Data Processes: Work with the data engineering team to enhance data processing, storage, and retrieval for better performance and scalability.
8. Provide Technical Leadership: Offer guidance and mentorship to the data team.
9. Perform other duties as assigned.

Career Level Expectations:

• Recognized master in designated professional discipline (typically obtained through post-secondary education and work experience) and is recognized as a master within and outside of the organization.
• Establishes operational plans for job area.
• Develops and implements new products, processes, standards, or operational plans that will have impact on the achievement of functional results.
• Requires communication with leadership.
• Desire for growth and professional development.

Required Skills/Experience:

• Bachelor's degree in computer science, IT, or related field.
• 5+ years' experience as a data solutions architect, or related role.
• Data modeling, ETL processes, and data warehousing.
• Azure Data Factory, Azure Databricks, SQL Server and PowerBI.
• Databricks solution development including Delta Live Tables in near-real time use cases.
• Certification in Databricks, Azure, or related.
• Skills - legacy SQL server-based systems, problem-solving, attention to detail, communication, and collaboration.
• Ability to professionally communicate fluently in verbal and written English.
• Ability to support a diverse and inclusive work environment.

Preferred Requirements:

• Any advanced degree or equivalent experience, especially in computer science, IT, or a related field.
• Strong or advanced proficiency in any of the above required skills/experience.
• Proficient in MS Office (Word, Excel, PowerPoint) and other business tools such as Microsoft Teams.
• Other skills or abilities - experience with cloud platforms and big data technologies, knowledge of governance and compliance standards, and/or experience with educational data systems.

Compliance:

• Demonstrate knowledge of and carefully follow all applicable state laws and rules, federal and state compliance requirements and regulations including those prescribed by the U.S. Department of Education, accrediting agencies, state regulations and internal policies and procedures.
• Effectively communicate compliance requirements to other staff as appropriate and quickly escalate any compliance concerns to the Compliance department.

Work Environment/Physical Demands:

• This is a full-time remote position.
• Home office set up, quiet place to work, and ability to hard wire into high-speed internet connection.
• May require setup of computer equipment; accommodation consideration available upon request.
• Flexibility to work evenings and weekends, as needed.