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