Senior ETL Developer

Job Title - Senior ETL Developer

Duration - Long term

Location - Chicago, IL (Remote)

Job Description:


Key Required Skills-


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-
• Collaborate with cross-functional teams to understand business requirements and translate them into technical ETL solutions.
• Design and develop data models, ETL processes and SQL queries to extract and manipulate data required for BI reporting.
• Optimize data loading strategies to achieve efficient use of resources and minimize processing time.
• 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.
• 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.
• All other duties as assigned or directed

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
• Masters or Doctorate degree may substitute for required experience
• 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.

Factors to Help You Shine (Required Skills):


These skills will help you succeed in this position:
• ETL Process Design, Development and Enhancement:


o Experience architecting end-to-end ETL solutions, from data extraction to loading, ensuring scalability, reliability, and performance.


o 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.


o Ability to evaluate and enhance existing ETL processes to ensure efficient data transformation, cleansing, and loading.


o Experience identifying bottlenecks and optimizing ETL workflows to improve data quality, accuracy, and processing speed.


o Experience creating and maintaining comprehensive documentation for ETL workflows, data lineage, and transformations.
• Data Modelling and Data Warehousing:


o In-depth knowledge of database concepts and proficiency in working with relational databases (e.g., PostgreSQL, Oracle, SQL Server).


o Strong SQL skills and familiarity with data warehousing concepts.


o Experience designing and developing data models that facilitate accurate and efficient self-service reporting and analysis.


o Expertise in both Dense and Sparse loading techniques, employing them based on specific data scenarios and requirements.
• Reporting


o Experience designing and developing Tableau visualization solutions.


o Experience developing interactive dashboards, charts, pivots, and reports in Tableau Desktop 2021.1 or higher using advanced calculations, parameters, and data blending.


o 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.


o Experience with other BI tools (e.g., Power BI, QlikView, MicroStrategy)
• Experience with cloud-based data platforms (e.g., AWS, Google Cloud, Azure) and related services (e.g., S3, Redshift, BigQuery)
• Comprehensive knowledge of Scrum and/or Kanban Agile development process and ceremonies (scrums, backlog grooming, retrospectives, demonstrations).
• 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.


How to Stand Out from the Crowd (Desired Skills)


Showcase your knowledge of Tableau through the following experience or skills:
• Prior SSA or Federal government experience.
• Experience with Tableau Prep and/or other Tableau products (Data management, Server management).


Education
• 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
• Must be able to obtain a Public Trust