Data Engineer - Technical Lead

We are seeking a Technical Lead Data Engineer (located in Atlanta, GA or willing to relocate) that has the skills to bring substantial experience in Data Solutions in order to help unlock the power of our data for the Company's Stakeholders. In this role, you will handle the increasing complexity and demand for data from various sources, enabling business to make informed decisions. You will also provide technical leadership to team of ETL developers in designing and implementing a cutting-edge data platform and pipelines. This position includes Technical Data leadership that includes working closely with business analysts and stakeholders in other departments to identify, recommend, develop, implement, and support data solutions.

Must have:

Strong Snowflake is a must and moving data from legacy systems. SSIS and SQL is a must. Azure is the new Environment so that is definitely a nice to have but will consider other cloud techs but Azure will take preference

In order to be considered for this contract to hire opportunity, you must live in Atlanta, GA or be willing to relocate.

Key Responsibilities (Essential Duties and Functions)

• Effectively communicate complex technical concepts to business stakeholders, helping them understand the development process and set realistic expectations.
• Offer guidance and recommendations to the development team, stakeholders based on best practices and industry trends and maximize the return on the investment.
• Clarify/translate requirements, data strategy into Epics/Stories & remove ambiguity and provide accurate estimates of the time and resources needed to complete tasks.
• Anticipate potential challenges or edge cases, addressing them before they escalate into significant issues.
• Collaborate between business stakeholders and development teams, ensuring everyone’s input is considered, and the project stays on track.
• Lead the design and implementation of the data & analytics architecture ensuring compliance, quality and a sustainable growth of the platform.
• Mentor and train other data team members and business users as needed.
• Build scalable data pipelines to integrate and model datasets from different sources that meet functional and non-functional requirements.
• Provide the technology, the tools and data to support enterprise-wide reporting, analytics, data science and self-service need.
• Delegating tasks and work with the technical team to achieve established timeline.
• Ensure the data quality by implementing and monitoring a data quality framework together with the data source teams.
• Formulate and complete end-to-end analysis that includes data gathering, analysis, ongoing scaled deliverables, and presentations.
• Help to grow our data team with right talents.

Qualifications

• Master or Bachelor’s Degree in Engineering/Computer related discipline, or equivalent experience required
• 10+ years of ETL / ELT Design, development and implementation experience using standard ETL/ ELT tool
• 10+ years of SQL Development Experience
• 7+ years of experience defining and managing ETL / ELT using tools and industry standard practices.
• 3+ years of Cloud (Azure preferred) experience
• 3+ years of Snowflake (must have) experience
• Fivetran is preferred
• dbt Cloud is nice to have
• 3+ years of SQL Server Reporting Services (nice to have)
• 2+ years of experience leading, coaching, and providing mentorship to ETL developers in an agile environment.
• Hands-on and deep experience using Star/Snowflake for schema design, data modeling, data pipelines.

Skills and knowledge

• Advanced knowledge of SQL databases and queries.
• Advanced knowledge of CDC (Change Data Capture) & CT (Change Tracking) inner workings.
• Experience in implementing and supporting several different ETL / ELT solutions.
• Experience in working with many different data sets, large and small.
• Experience working with data in multiple ERP and data movement technologies.
• Experience with normalizing and de-normalizing data and creating different fit-for-purpose data model.
• Knowledge of ETL best practices and standards.
• Ability to quickly resolve issues.
• Experience with Cloud (Azure - nice to have), Snowflake, SQL Server 2014 – SQL Server 2019 , SQL Server Reporting Services , SQL Server Integration Services.
• Ability to present ideas in concise, business-friendly and user-friendly language.
• Excellent written, interpersonal and verbal communication skills.
• Experience with managing and collaborating with multidisciplinary teams.
• Experience with design and development of EDW (Enterprise Data warehouse) is preferred.
• Experience with Data Lakehouse, Data Fabric architecture framework is preferred.