Lead Data Engineer

Software Guidance & Assistance, Inc., (SGA), is searching for a Data Engineer for a contract assignment with one of our premier Insurance services clients in Hartford, CT.

Responsibilities :

• Design and develop high quality, scalable software modules for next generation analytics solution suite
• Prototype high impact innovations, catering to changing business needs, by learning and leveraging new technologies (AWS Cloud, Big Data, Snowflake, Informatica Cloud).
• Integrate with Data Quality Services to ensure Quality data is Published to consumers.
• Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of varying technical complexity
• Consults with functional management in the analysis of short and long-range business requirements and recommends innovations which anticipate the future impact of changing business needs
• Works closely with client management to identify and specify the complex business requirements and processes for diverse development platforms, computing environments (e.g., Cloud, host based, distributed systems, client server), software, hardware, technologies and tools
• Exposure to CI/CD processes and experience working with GIT, Jenkins, Urban Code Deploy, Nexus repositories
• Coordinate activities with cross-functional IT unit stakeholders (e.g., database, operations, telecommunications, technical support, etc.)
• Researches and evaluates alternative solutions and recommends the most efficient and cost-effective solution for the systems design
• Work within a self-organized scrum development team regarding all design and implementation

Required Skills:

• Bachelor's degree with at least 5 or more years of applicable work experience with respect to Data Analysis, manipulation, and technical development
• Desired educational experience includes, but are not limited to: Computer Science, Engineering, IT, Management Information Systems, Data Analytics, Applied Mathematics, and Business.
• Desire candidates with prior Data Engineer/ETL competencies and prior experience with successful enablement of Data Delivery initiatives.
• Knowledge of ETL tools like Informatica & Talend; relational databases like Oracle & Snowflake; Oracle PL/SQL etc.
• Understanding of current and emerging IT products, services, processes and methodologies.
• Analytical approach with a strong ability to uncover and resolve problems by delivering innovative approaches and solutions.
• Technical leadership with respect to design, implementation and overseeing complex technical processes
• Strong ability to estimate project tasks and to deliver upon committed dates. Ability to develop and maintain systems according to a defined set of standards.
• Ability to work as part of and with high performing teams.

Preferred Skills:

• Experience with AWS Services (i.e. S3, EMR, etc) a plus
• Experience with Cloud data warehouses, automation, and data pipelines (i.e. Snowflake, Redshift) a plus
• Experience using Gen AI solutions to automate data engineering pipelines preferred.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.