What are the responsibilities and job description for the Lead Developer position at Complete Health?
SUMMARY OF JOB DUTIES:
We are looking for an experienced and dynamic Lead Developer to join our team. The ideal candidate will bring extensive expertise in ETL pipelines, database management, and data transformation tools, with a proven ability to lead projects and mentor development teams. You will play a pivotal role in designing and implementing modern data integration solutions using SSIS, SQL, Python, Apache Airflow, and DBT.
ESSENTIAL JOB FUNCTIONS:
- Lead Development Efforts: Manage end-to-end development processes, guiding a team of developers through project design, coding, testing, and deployment phases.
- ETL Pipeline Management: Develop, optimize, and maintain ETL workflows using SSIS, SQL Server, and Apache Airflow.
- Data Transformation: Utilize DBT to design and implement robust data models and transformations, ensuring data quality and consistency.
- Automation and Optimization: Develop Python scripts to automate data ingestion, processing, and integration tasks, reducing manual effort.
- System Integration: Oversee the seamless integration of data across diverse systems, ensuring high availability and reliability.
- Data Warehouse Development: Architect and enhance data warehouse solutions to support analytics and reporting needs.
- Collaboration: Work closely with cross-functional teams, including data analysts, business stakeholders, and other developers, to understand requirements and deliver effective solutions.
- Code Reviews and Best Practices: Conduct code reviews, enforce best practices, and mentor junior team members.
MINIMUM REQUIREMENTS
- Education: Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
- Experience:
- 10 years of software development experience, with a focus on data integration and transformation.
- At least 3 years in a leadership or team management role.
- Technical Proficiency:
- Strong hands-on experience with SSIS and SQL Server.
- Expertise in scripting and automation using Python.
- Experience with Apache Airflow for workflow orchestration.
- Proficiency in DBT for data modeling and transformation.
- Familiarity with modern data warehouses such as Snowflake or similar platforms.
- Experience in reporting and data visualization tools such as Tableau or SSRS.
