BI ETL Developer/ Data Engineer Job at Apptad Inc, Austin, TX

R1NtTXdaWll5Vmwxck53SzJ3cDlpaXQ5cXc9PQ==
  • Apptad Inc
  • Austin, TX

Job Description

Job Title: BI ETL Developer/ Data Engineer

Job Location: Austin, TX

Required Skills: Strong ETL, SQL expert with knowledge on python.

  • ETL concepts
  • Data Warehousing concepts
  • Advanced SQL Concepts
  • Data Validation/Data Quality Check
  • CI/CD techniques.
  • Programming language: JAVA, Python
  • Cloud Platform: GCP

Primary Roles & Responsibilities :

  • Manage the end-to-end lifecycle of data pipelines, including extraction, transformation, and loading into the Google Warehouse (GCP).
  • Conduct in-depth data analysis and apply statistical methods to derive insights.
  • Execute code development within the designated DEV environment.
  • Perform comprehensive validation and testing prior to deploying code to UAT or other staging environments.
  • Document and maintain records of all test outcomes.
  • Facilitate the code submission process by preparing ChangeLists for peer review.
  • Oversee the final deployment of code across multiple environments, including UAT, PREPROD, and PROD.

Job Description:

  • Develop and manage ETL data pipelines to populate the data warehouse using various custom and third-party systems.
  • Create, deploy, and refine comprehensive full-stack Data and BI solutions, covering everything from extraction and storage to transformation and visualization.
  • Utilize SQL and Python to build and maintain robust data analysis scripts.
  • Provide ongoing support and development for dashboards and reports via Google PLx and Looker Studio.
  • Enhance existing business intelligence tools and create new dashboards to drive organizational growth.
  • Conduct detailed data examinations and apply statistical analysis techniques.
  • Monitor performance and implement necessary infrastructure optimizations
  • Demonstrate excellent collaboration, interpersonal communication and written skills with ability to work in a team environment.

Minium Qualification:

  • Candidates must possess at least 6-8 years of professional experience.
  • Due to the high-velocity nature of this project, individuals with extensive experience will achieve the most effective results.

Responsibilities in this role :

  • Design, develop, and maintain scalable and robust ETL/ELT processes and data pipelines using various tools and technologies.
  • Build and optimize data warehouses, data lakes, and other data storage solutions to support analytical and operational needs.
  • Implement data quality checks and monitoring to ensure the accuracy, completeness, and consistency of data.
  • Work with large datasets, performing data modeling, schema design, and performance tuning.
  • Create data models that are easy for BI tools to consume and build dashboard.

Job Tags

Similar Jobs

Graham Healthcare Group

Internal Auditor Job at Graham Healthcare Group

Compensation: $75,000.00 - $95,000.00 On-Site - Plano, TX - Monday - Friday 8AM - 5PM CST. Hybrid after 90 days, working 2 days from home. Benefits: Medical, Vision, and Dental Retirement: 401K & Pension w/4% Match PTO: 15 Days The Internal Controls Specialist will be... 

Lensa

Digital Media Coordinator Job at Lensa

 ...recruitment ad agencies, and marketing partners. Lensa partners with...  ...and detail-oriented Digital Media Coordinator to support our global...  ...and media efforts. This entry-level role is ideal for someone who...  ...Responsibilities Assist in scheduling social media content (LinkedIn, X/... 

zTrip World Wide

Mobility Care Driver Job at zTrip World Wide

Make a Difference Behind the Wheel Become a Mobility Care Driver with zTrip Do you have a passion for helping others? zTrip is looking for Mobility Care Drivers to provide safe, dependable transportation for passengers with special mobility needs. As the largest...

Edward M. Kennedy Community Health Center, Inc.

Dental Receptionist Job at Edward M. Kennedy Community Health Center, Inc.

 ...sites to support this growth. We are currently hiring a Dental Receptionist based in Worcester, MA. The Dental Receptionist is responsible...  ..., and accurate data entry typing. ~1-2 years work experience within a position requiring the use of excellent customer service... 

Ardent Health

Medical Assistant / Urgent Care MA Job at Ardent Health

 ...Join our team as a full-time , Medical Assistant in Stillwater, OK. Why Join Us? Thrive in a People-First Environment and Make Healthcare...  ...and a supportive, inclusive culture where you are valued and cared for. Make Healthcare Better: We use advanced technology...