| senior ETL developer at Remote, Remote, USA |
| Email: [email protected] |
| From: Vicky, istaffx [email protected] Reply to: [email protected] 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 Skills Requirements: Basic Qualifications: 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. Required Skills: ETL Process Design, Development and Enhancement: Experience architecting end-to-end ETL solutions, from data extraction to loading, ensuring scalability, reliability, and performance. 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. Ability to evaluate and enhance existing ETL processes to ensure efficient data transformation, cleansing, and loading. Experience identifying bottlenecks and optimizing ETL workflows to improve data quality, accuracy, and processing speed. Experience creating and maintaining comprehensive documentation for ETL workflows, data lineage, and transformations. Data Modelling and Data Warehousing: In-depth knowledge of database concepts and proficiency in working with relational databases (e.g., PostgreSQL, Oracle, SQL Server). Strong SQL skills and familiarity with data warehousing concepts. Experience designing and developing data models that facilitate accurate and efficient self-service reporting and analysis. Expertise in both Dense and Sparse loading techniques, employing them based on specific data scenarios and requirements. Reporting Experience designing and developing Tableau visualization solutions. Experience developing interactive dashboards, charts, pivots, and reports in Tableau Desktop 2021.1 or higher using advanced calculations, parameters, and data blending. 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. 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. Desired Skills Prior SSA or Federal government experience. Experience with Tableau Prep and/or other Tableau products (Data management, Server management). Benefits include: Comprehensive medical, dental, vision, life, and short & long-term disability insurance + health savings account Matching 401k retirement plan + IRA's and Roth IRA's Generous paid time off and paid holidays Employee recruitment/referral bonus Paid community service hours Tuition reimbursement Employee discounts Keywords: business intelligence sthree rlang |
| [email protected] View all |
| Fri Aug 11 21:36:00 UTC 2023 |