Lead Developer

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.

Innovation: Stay current with emerging technologies and recommend innovative solutions to meet business challenges.

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.