Lead Data Engineer

Summary
CommunityAmerica Credit Union is seeking a strong and experienced Lead Data Engineer as part of its Data Platform team to build scalable enterprise data solutions that drive strategic business outcomes. The goal of the Data Platform Team is to execute on a data and analytics strategy that enable personalized member experience and help achieve CommunityAmerica's membership growth, engagement, and well-being strategic goals.
As a Lead Data Engineer in the Data Platform team, you will partner with Product Owners on strategic initiatives, understand business and functional requirements on projects, provide hands-on technical leadership to the engineering team with project execution and ensure deliverables are delivered with high quality and on time. You will help lead the iterative design and development of our cloud data warehouse. You will be responsible for designing, developing and maintaining data pipelines and data in our data warehouse to support Data Science, Business Intelligence and business operations. You will lead and guide the data engineering team, ensuring adherence to quality, standards, processes, and methodologies. Additionally, you will support the team in overcoming any technical challenges they encounter.
Duties & Responsibilities

• Work closely with Product Manager and business stakeholders and develop a strong business understanding of CommunityAmerica strategic and project level data needs.
• Work with Product Owners to understand and translate business requirements into technical specifications and logical & physical data model requirements.
• Design and extend data models working closely with Product and Data Architecture.
• Design data pipelines that process both real time and batch data leveraging modern data engineering best practices.
• Build, implement and test data pipelines using Databricks, Azure Data Factory, SSIS and other data integration tools.
• Take technical ownership of projects and ensure deliverables meet scope, quality and timelines.
• Provide technical leadership and guidance to the data engineering team, including mentoring, coaching, and fostering a collaborative work environment between all team members.
• Support team members with troubleshooting and resolving complex technical issues and challenges.
• Implement coding standards, conduct code reviews to ensure proper code quality level.
• Implement effective source code management and CI/CD best practices to ensure data pipelines are automatically tested, integrated and deployed to production.
• Partner with Data Architects to implement effective data integration and storage design patterns. Contribute to continously improve existing data architecture and frameworks.
• Assist in the development and implementation of data governance and management solutions.
• Stay abreast with evolution of cloud Data technologies, frameworks, and best practices to continuously evolve CommunityAmerica's Data platform and solutions.
• Promotes honest and open communication throughout the credit union.
• Demonstrate behaviors that are consistent with the credit union's values, philosophies, and leadership characteristics.

Requirements
Education and Experience Requirements:

• Bachelor's Degree or higher in Computer Science, Engineering, or related field required.
• 10+ years of experience in data engineering and data warehousing.
• 5+ years of cloud data engineering and big data experience.

Required Knowledge, Skills and Abilities:

• Experience with cloud data engineering and data warehouse technologies in Microsoft Azure, Google or AWS. Experience in Azure is highly preferred.
• Strong programming skills in python and SQL for data processing and automation.
• Strong technical skills in big data and Data integration technologies including Spark, Kafka, Databricks, Azure Data Factory, SSIS and SQL.
• Experience with designing and building both cloud and on-prem data warehouses. Experience with Lake house architecture is highly preferred.
• Experience in data modeling for transactional and analytical needs. Experience with NoSQL databases is preferred.
• Development experience in Microsoft SQLServer including experience with tuning queries to optimize performance.
• Skilled in Visual Studio with the use of source control applications such as Azure DevOps.
• Experience with CI/CD and Jenkins.
• In-depth knowledge of data management principles and best practices, including data governance, data security, data quality, and data integration.
• Experience with delivering data solutions iteratively using the Agile Scrum framework and development processes.
• Experience in providing guidance, mentorship, and technical support to a team of data engineers.
• Demonstrated ability to troubleshoot and resolve complex technical issues related to data processing in a cloud big data infrastructure.
• Exceptional analytical and conceptual thinking skills coupled with strong written and verbal communication skills.
• Excellent interpersonal skills, with the ability to effectively collaborate with cross-functional teams, stakeholders, and senior management.
• Able to communicate effectively, both written and orally, with internal and external customers, vendors, and partners.
• Ability to interact effectively with co-workers to accomplish daily tasks and to resolve interpersonal conflicts and miscommunications.
• Thrives in ambiguous technology situations.

Preferred Knowledge, Skills and Abilities:

• Financial industry knowledge.
• Development experience with Power BI and SSRS/Power BI Paginated reports.