The Center for Creative Leadership (CCL) is a top-ranked nonprofit global provider of leadership development solutions with a mission to advance the understanding, practice, and development of leadership for the benefit of society worldwide. The Societal Impact division of CCL focuses on leadership development in four vertical areas of practice: K12 education, Higher Education, Nonprofit, and Population Health. The Development team works collaboratively with the different vertical directors, faculty, operations, and the CCL enterprise to provide high-quality, high-impact leadership solutions to our clients.

As a Senior Data Engineer, you will design, build, and maintain data infrastructure that powers CCL's analytics and data science initiatives. This includes developing and maintaining data pipelines, data warehouses, and data lakes using the latest Microsoft technologies. The Senior Data Engineer will also be responsible for implementing practices to ensure compliance with data privacy and security policies.

Principal Duties and Responsibilities

• Design, build, and maintain scalable and efficient data pipelines for acquiring, processing, and storing structured and unstructured data
• Design, build, and maintain data lake and data warehouse solutions in accordance with the architecture and standards
• Create and maintain data models that capture the organization's data requirements and enable efficient data retrieval and analysis
• Design, build, and maintain practices to ensure compliance with data privacy and data governance policies
• Continuous improvement of data engineering processes and development practices

Specific Functional Work Experience Required

• 7+ years of experience in a data engineering role or similar job-related experience
• Proven record of accomplishment designing and implementing complex data integration solutions using Microsoft Azure technologies
• In-depth knowledge and hands-on experience with Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, Microsoft Fabric, Azure Cloud Storage, and Azure Cosmos DB
• Hands-on Lakehouse development experience using Delta Lake
• Extensive experience in dimensional and relational data modeling, database design, and optimization
• Expert-level SQL and T-SQL skills and experience
• Hands-on experience using the Spark data processing framework
• Hands-on experience automating processes with a programming language such as Python and PowerShell
• Practical experience implementing data quality, data privacy, and data security measures
• Hands-on experience using Microsoft Power BI

• Excellent documentation and communication skills, with the ability to articulate complex technical concepts clearly
• Continuous learning mindset and commitment to stay current with advances in Microsoft data and analytics technologies
• Proven ability to work collaboratively in a team environment and to drive successful data engineering initiatives
• Familiarity with Agile development methodologies and experience working in Agile teams
• Ability to adapt to changing project requirements and priorities, deliver results in iterative cycles, and participate in sprint planning and reviews
• Strong leadership abilities, with the capacity to provide technical mentorship and guidance to junior team members

• The hiring range for this role starts at $116,000 - $128,000. Offer will be commensurate with relevant qualifications and professional experience.
• This is a fully remote position open to candidates based in the United States. Applicants must be eligible to work in the United States.
• Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
• 403(b) Savings Plan with employer contribution
• Medical insurance
• Telemedicine
• Dental insurance
• Vision insurance
• Health savings and flexible spending accounts
• Paid time off and paid holidays
• Employer-paid short-term and long-term disability
• Employer-paid life insurance
• Employee and family assistance program
• Various voluntary options for additional plans or coverage levels