ETL Developer

Data And Analytics Developer

Responsible for coding, modifying, debugging, and documenting Data and Analytics applications that best support Office of Internal Audit (OIA) business requirements. You will also modify moderately complex Data & Analytics application programs, including detailed data design, ETL and Data Warehousing.

• Plan, design, develop, modify, debug and evaluate moderately complex Data and Analytics software for the OIA business unit.
• Analyze existing ETL jobs, data warehouse applications or work to formulate logic for moderately complex new systems and devise moderately complex algorithms.
• Perform data analysis and test/debug software solutions.
• Design and extract data from different data sources such as Guidewire, Oracle Fusion, and other SQL Server databases.
• Apply effective programming security practices.
• Knowledge of RPA tools such as UiPath to automate unstructured data extraction and improve operational efficiency.
• Collaboratively work with Internal Audit, Enterprise Risk and Internal Control teams to help with their data extraction and analytics needs

• 10+ years of development experience in data ingestion, data transformation, and data load
• Advanced knowledge of ETL tools such as SSMS, SSIS, Microsoft SQL Server
• Experience in or knowledge of Azure Data platforms such as Azure Data Factory, Azure Synapse, Azure ADLS Gen2, etc.
• Certification in Data Engineering or ETL (highly desirable)
• Advanced knowledge of secure data development, including design and implementation leading practices
• Demonstrated broad problem-solving skills, including experience identifying and using code libraries and open-source forums.