ETL Administrator #4066

Company Overview

GovCIO is a team of transformers—people who are passionate about transforming government I.T. We believe in making a difference by developing digital strategies and delivering the technology-related innovation governmental operations that improve the citizen experience every day.

But we can’t do it alone. We welcome and nurture an inclusive and diversified work culture. Because different backgrounds, experiences, abilities, and perspectives make us better decision-makers, problem solvers, and creators. We’re changing the face of I.T. – from our diverse staff to the end-products we develop. And we’re excited to expand our team. Are you ready to be a transformer? 

Responsibilities

• Interact with officially designated product owners, system owners, and business owners of the source systems to understand transactional system data models and elicit requirements and logic for the ETLs
• Translate business requirements and develop ETL workflows/data pipelines to ingest data using Informatica, AWS Data Migration Service (DMS), Scala, Kafka, Restful APIs, and other technologies as determined by the client from multiple transactional systems to the target (including ODS, data marts, and data lake) according to documented logic and source-to-target mappings 
• Re-develop legacy ETL code (i.e., PL/SQL, Materialized Views, Informatica PowerCenter) into modernized data pipelines (e.g. AWS DMS, Databricks Scala, Kafka Streaming Topics)
• Troubleshoot data discrepancy and missing data issues resulting from daily ETL loads
• Work with operations team to deploy ETL jobs in integration and production environment and debug / troubleshoot critical production issues
• Implement procedures to maintain, monitor, backup and recover operations for ETL environment
• Report regularly on health and performance of ETL environment and jobs
• Conduct ETL optimization, troubleshooting and debugging
• Maintain ownership of release activities interacting with ETL projects
• Perform import and export ETL jobs across various ETL projects and servers
• Provide development support to ETL application development teams
• Establish projects, roles, users, privileges in different ETL environments (DEV, QA, PROD)
• Perform and assume other duties and responsibilities as required at direction of management
• Perform administration of IBM Database and ETL tool
• Collaborate with US data warehouse and ETL developers to implement ETL solutions
• Establish ETL admin as part of team responsible for building out and maintaining US data warehouse
• Record and maintain ETL software and operational procedures
• Perform independently with little direct supervision in administration of ETL
• Provide detailed analysis of problems and recommend solutions
• Conduct troubleshooting production and ETL job issues
• Adopt and comply with the Agile Analytics approach and provide skills and expertise in Agile development and apply it effectively to DW/BI development
• Actively participate in Agile release and sprint planning, sprint grooming, artifact creation, sprint testing, demonstrations and retrospectives and solution releases.
• Document ETL logic, mappings, etc. in a concise and traceable manner consistent with an Agile development approach to be used as a reference for future development and maintenance
• Execute other activities related to development work, such as participate in meetings, provide briefings, presentations and other support materials that will promote the program, assist in achieving user buy-in, and explain technical concepts to non-technical audiences 

Qualifications

• Bachelor’s degree in a technical discipline preferred – Computer Science, Mathematics, or equivalent technical degree, or the equivalent combination of education, professional training, and work experience with 12+ Years (or commensurate experience)

• 3+ years of experience with ETL development ingesting data from diverse and large data sources
• 3+ years of experience with programming languages such as Java, Scala, Python, R, JSON
• 3+ years of experience with relational databases used to support BI analytics
• 3+ years of experience in technical development and leadership roles on BI projects, including designing and developing with ETL Tools 
• 3+ years of experience working in AWS Cloud environment
• Experience with Databricks/Apache Spark, AWS Data Migration Service (DMS), and/or Informatica PowerCenter 9.5 or higher
• Experience with ETL Process Management to include establishing boundaries of data processing, building system architecture for the data pipeline, drawing up technical documentation for system requirements, and participate in the determination and implementation off ETL and testing tools
• Knowledge of Scripting languages e.g., Perl, Bash, Python, Java
• Demonstrated experience using Terraform to deliver ETL and infrastructure solutions in AWS
• Demonstrated experience in a Data Warehouse and Business Intelligence environment
• Strong teamwork, co-ordination, planning and influencing skills
• Self-driven with the ability to adapt quickly, work in a challenging and fast paced environment within cross-functional teams, and to promote creative problem solving within their team
• Knowledge of the Agile, including Scrum and Kanban, and management tools (e.g., Jira, Confluence)
• Excellent analytical, communication and organizational skills
• Experience with GitHub and branching strategies
• Experience with Microsoft Office Suite including Excel, PowerPoint, and Visio