Senior ETL Developer Job at Maintec Technologies, United States

  • Maintec Technologies
  • United States

Job Description

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

Job Tags

Remote work, Flexible hours

Similar Jobs

Triple Crown Corporation

Architectural Drafter/Designer Job at Triple Crown Corporation

Job Title Location 6385 Flank Drive, Suite 100, Harrisburg, PA, 17112, United States Employee Type Full-time Contact Information Name Emily Hombach - HR Recruiter Phone (***) ***-**** Email ****@*****.*** Pay Type Salary

Dallas Convention & Visitors Bureau

Marketing Internship - DSC 2027 Job at Dallas Convention & Visitors Bureau

 ...end in August of 2027. QUALIFICATIONS : On the job social media experience with knowledge of Facebook, Instagram, Twitter, TikTok and YouTube. Website management knowledge a plus. Ability to multi-task multiple projects and be detail oriented. Excellent... 

Segue Inc

Mental Health Advocate - Community-Based ACT Services Job at Segue Inc

 ...Job Description Job Description Mental Health Advocate Community-Based ACT Services Jackson, MI | Full-Time | Starting at $20.00/hour | $4,000 Retention Bonus Make a difference where life actually happensin the community. Segue, Inc. is looking for a compassionate... 

KittySpout

Social Media Manager Job at KittySpout

 ...KittySpout / DoggySpout is looking for a Social Media Manager to join our team! You will own organic social for both brands end to end across every social channel. You decide what each account is for, who it should bring in and what content grows it. Then you plan... 

Atlas Recovery Systems. LLC

LPR Camera Truck-Recovery Agent Job at Atlas Recovery Systems. LLC

*LPR Camera Truck-Recovery Agent Position Open Immediately* Atlas Recovery Systems, LLC, a local repossession and asset recovery firm is seeking a repossession-recovery agent to join our team at our Overland Park, Kansas location. We are located in Overland Park but...