Senior Etl Developer Jobs

• ETL design, processes, tools (e.g. Ab Initio, Informatica), scripting, programming languages (e.g. Python, R), data modeling, data warehousing, relational databases (e.g. PostgreSQL), SQL, Tableau, cloud-based data platforms (e.g. AWS), related services

Position Description

• Design and develop data models, ETL processes and SQL queries to extract and manipulate data required for BI reporting.
• Design and develop robust interactive dashboards and reports in Tableau using data from a variety of sources.
• Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.
• Optimize data loading strategies to achieve efficient use of resources and minimize processing time.
• All other duties as assigned or directed
• Collaborate with cross-functional teams to understand business requirements and translate them into technical ETL solutions.
• Implement data structures that enable agile and flexible reporting capabilities.
• Analyze reporting requirements and data needs to ensure availability of data required to develop dashboards and reports.

Detailed Skills Requirements

Foundation for Success (Basic Qualifications):

This experience is the foundation a candidate needs to be successful in this position:

• Bachelor’s Degree in Computer Science, Mathematics, Engineering, or a related field
• 7+ years of demonstrated experience with design and development of ETL processes.
• 5+ years of demonstrated experience in data modeling, data warehousing, and writing SQL queries for data extraction and manipulation.
• 3+ years of demonstrated design and development skills using Tableau Desktop and Tableau Server to create interactive dashboards and visualizations.
• Masters or Doctorate degree may substitute for required experience

Factors to Help You Shine (Required Skills):

These skills will help you succeed in this position:

• Experience with cloud-based data platforms (e.g., AWS, Google Cloud, Azure) and related services (e.g., S3, Redshift, BigQuery)
• Expertise in both Dense and Sparse loading techniques, employing them based on specific data scenarios and requirements.
• Strong SQL skills and familiarity with data warehousing concepts.
• Strong experience designing and developing complex ETL workflows using tools (e.g., Ab Initio, Informatica) and/or scripting languages (e.g., Python), incorporating best practices for data transformation and loading.
• Reporting
• Experience connecting to varied data sources for BI reporting purposes, including but not limited to, Oracle 19c or above, DB2, Greenplum, SQL Server, and other enterprise data sources.
• Ability to evaluate and enhance existing ETL processes to ensure efficient data transformation, cleansing, and loading.
• Experience developing interactive dashboards, charts, pivots, and reports in Tableau Desktop 2021.1 or higher using advanced calculations, parameters, and data blending.
• ETL Process Design, Development and Enhancement:
• Experience designing and developing Tableau visualization solutions.
• Experience identifying bottlenecks and optimizing ETL workflows to improve data quality, accuracy, and processing speed.
• Strong communication and collaboration skills in providing technical direction and hands-on development to include design, development, and testing.
• Ability to lead and present complex technical concepts in front of a wide audience composed of users, business leaders, and technical experts.
• Comprehensive knowledge of Scrum and/or Kanban Agile development process and ceremonies (scrums, backlog grooming, retrospectives, demonstrations).
• Data Modelling and Data Warehousing:
• In-depth knowledge of database concepts and proficiency in working with relational databases (e.g., PostgreSQL, Oracle, SQL Server).
• Experience designing and developing data models that facilitate accurate and efficient self-service reporting and analysis.
• Experience with other BI tools (e.g., Power BI, QlikView, MicroStrategy)
• Experience creating and maintaining comprehensive documentation for ETL workflows, data lineage, and transformations.
• Experience architecting end-to-end ETL solutions, from data extraction to loading, ensuring scalability, reliability, and performance.

How to Stand Out from the Crowd (Desired Skills)

Showcase your knowledge of Tableau through the following experience or skills:

• Experience with Tableau Prep and/or other Tableau products (Data management, Server management).
• Prior SSA or Federal government experience.

Education

• Must be able to obtain a Public Trust
• Master’s degree and 5+ years of experience in a related field or bachelor’s degree and 7+ years of experience in a related field

REF: JOB-4385