What are the responsibilities and job description for the Senior Data Engineer position at CCL Brand?
Who We Are
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.
General Summary
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
Required Knowledge, Skills, or Abilities
- 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
Pay and Benefits
- The hiring range for this role starts at $116,000 - $128,000. Offer will be commensurate with relevant qualifications and professional experience.
- 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
Salary : $116,000 - $128,000