The primary responsibilities of the Sr. ETL Software Engineer include warehousing, design and development of logical and physical data models and databases, distributed data management and providing ongoing production support of existing solutions, along with designing, executing, and debugging manual test plans to ensure business requirements are met. The ideal candidate must be able to perform data analysis tracking data elements from the source, through transformation all the way to the target destination. The Sr. ETL Software Engineer delivers business intelligence solutions, including multi-dimensional database models (logical and physical), data marts, data warehousing, data transformations, data analytics, and supports reporting solutions while collaborating with business users to set requirements for solutions. Relies on experience and judgment to plan and accomplish goals. A certain degree of creativity and latitude is required.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective to derive software designs and performance solutions.
Design, implement, execute and debug manual test cases and automated test scripts using a variety of testing techniques.
Strong data analysis skills and the ability to track a data element from source to transformation to target.
Designs and develops relational and multidimensional data models and optimizes the data-mining performance function including the use of data modeling tools, preferably Erwin.
Creates and implements BI reporting solutions, Extract Transform Load (ETL) solutions using best practices and methodologies; identifies root causes of issues with data quality and other related issues.
Designs and codes new software or enhances existing software and integrates into new or modified systems and/or operational environments.
Works with a reporting team optimizing the ETL/data pipeline process to ensure that business requirements are met.
Secure sensitive content to align with regulatory and legal requirements.
Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.
Mentors junior staff.
Provide on-call production support on a rotating basis.
TECHNICAL, MANAGERIAL, and PEOPLE SKILLS REQUIRED:
To perform this job successfully an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Incumbents will be evaluated, in part, based on performance of each essential function. Appropriate reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
EDUCATION and/or EXPERIENCE:
The appropriate candidate for this position would possess a strong business acumen working independently and across teams. We are looking for driven self-starters who are able to collaborate across all levels and teams within an organization. Effective written and oral communication is a must. Advanced knowledge of Microsoft Office suite (including MS Access) required. Experience working in an Agile development environment a plus.
Undergraduate degree in computer science or at least 4 years’ of work experience in relevant field.
At least 4 years’ experience implementing ETL solutions (e.g. SSIS, Informatica or equivalent) required.
Experienced in writing complex T-SQL statements, scripts, stored procedures, triggers and views implement business intelligence and data warehousing solutions.
Experience in extracting data from heterogeneous data sources.
Solid foundation in, and application of, data warehousing and reporting platform concepts with ability to recommend solutions and drive best practices.
Familiarity with Oracle, SQL Server, Cognos & Tableau (or similar) environments is a must.
Fluent in Spanish.
Conversational in Portuguese a plus.
Experience with cloud data warehousing or data integration as a service (such as Informatica Cloud) a plus.
Leadership Skills: A self-starter who can excel in a team environment and has the ability to personally solve problems, coach others, and can work in a matrix environment.
Strong Execution Skills: Contributes to continuous improvements of technology programs. The ability to understand needs to ensure technology plans are delivered as promised.
Strong analytical and problems solving skills debugging and correcting code in high-pressure situations correcting defects or improving performance.
Time Management: Use his/her time effectively and efficiently; values time; concentrates his/her efforts on the more important priorities.