Senior Data Engineer / ETL Developer

Duties & Responsibilities

• Work closely with IT and Business Teammates to identify potential business process candidates
• Cook with business partners to re-imagine and improve business processes as appropriate
• Design, develop, test, deploy and support Processes using CCCI best practices
• Contribute to the CCCI shared library of [Domain] components and best practices
• Participates in rotational on-call support, maintenance activities and other duties as determined by the team
• Develop and manage ETL processes with SQL Server, SSIS, ADF, and Snowflake for efficient data integration
• Writes code in lower-level (i.e. C-Sharp, .Net, Python) programming languages to optimize the performance and efficiency of an organization’s IT platform, infrastructure
• Configures customizes, diagnoses, and enhances SAAS, Off the shelf, In-House Developed or 3rd Party supplied systems software including operating systems software and utilities that manage access to peripherals, facilitate networking, manage memory allocation
• Writes diagnostic programs to test integrated software, hardware systems and resolve system faults to indicate that the program is not functioning properly or meeting the technical, functional requirements
• Participates and actively contributes to the following Agile Scrum events, as well as Backlog Grooming, including Sprint – a time box of 1-4 weeks during which a useable and potentially releasable increment of work is completed
• Sprint Planning – an event where the team determines what they can confidently complete in the upcoming Sprint, and self-organizes to plan the tasks needed to do so
• Daily Standup – 15-minute time-boxed event held every day of the Sprint for the Agile team to plan work for the next 24 hours. This optimizes team collaboration and performance
• Sprint Review – held at the end of the Sprint for the agile team to share with stakeholders what was done in the Sprint, elicit their feedback, and agree on the next Sprint’s work to optimize value to the business
• Sprint Retrospective - held at the end of the Sprint for continuous improvement of the team where the team inspects itself and creates a plan for improvements to be enacted during the next sprint
• Backlog Grooming – breaking down high-level ideas into independent, estimable, and testable increments of useable and potentially releasable units of work that can be completed within a Sprint
• Creates technical documentation of systems software programs and code to be leveraged for audit purposes and documents why the program was built

Knowledge, Skills, & Abilities

• Ability to Identify existing business processes suitable for [Domain]
• Demonstrated ability to take ownership of complex initiatives and drive them to successful completion.
• Ability to design well-structured and efficient processes and objects following standard principles and practices
• Ability to proactively coordinate security related best practices and solutions with IT security and agile delivery teams
• Ability to document, evangelize, and guide adoption and implementations across agile delivery teams
• Strong Analytical and Problem-solving abilities
• Strong understanding of data

Minimum Qualifications

• High school diploma or GED; 2 years of education beyond high school in college or technical school
• 5+ Years of experience in ETL
• 5+ Years of experience working with SQL
• Experience working with SSIS or ADF or other ETL tools.
• C#, .NET Integration development (console application) where console application Experience is Mandatory.
• 3+ Years experience in Domain-specific framework development

Preferred Qualifications

• Experience with Azure API Management.
• Experience with Azure Data Factory.
• Experience leading and mentoring technical teams in complex development environments.
• Agile Delivery in a Matrixed organizational Structure
• MS Azure Environment Development experience
• MS Azure DevOps or GIT experience
• Familiarity with data integrations and exchange frameworks (jSON, XML, EDI)
• BS in Computer Science or Information Technology related field