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