CloudRay Inc: Sr. ETL Developer United States


Developer is needed in United States.

This job has been crawled from the web.

Client: CloudRay Inc

Location: Remote

Contract: Contract


  • 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:

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):

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.

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


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

Posted 2 months ago
based in Manchester, United Kingdom
Last online: a day ago

No longer accepting applications

Don't miss out! Drop your email to get notified for Developer roles

  • How It Works

    Create your Profile for Free

    Build your Twine portfolio to highlight your skills, and experience, while setting your desired pay rate.

    Send Customized Pitches

    Pitch for available jobs that match your skills, and access exclusive opportunities that are specifically tailored to your expertise.

    Secure Payment Process

    Clients make upfront Vault payments held by Twine, ensuring freelancer payment security, with 0% commission for freelancers.