Talent.com
ETL/Data Warehouse Developer
ETL/Data Warehouse DeveloperMy3Tech Inc • Austin, TX, United States
serp_jobs.error_messages.no_longer_accepting
ETL / Data Warehouse Developer

ETL / Data Warehouse Developer

My3Tech Inc • Austin, TX, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.temporary
job_description.job_card.job_description

ERS ETL / Data Warehouse Developer

ITSAC Contract / Net 45 Payment Terms

Client : State of TX / Employees Retirement System (ERS)

Location : ERS is hybrid work from Home and Office . ERS is currently under a hybrid model, which involves at least 2 days in the office

Term of Service : 6 months - 990 hours

Work Hours and Location : M-F 8 : 00 - 5 : 00 PM, 200 E. 18th St, Austin, Texas 78701

Terms and Conditions :

  • Vendor will conduct a criminal history check on candidate recommended for the position.
  • ERS is currently under a hybrid model, which involves at least 2 days in the office, and the other days working from home (Days to be in office to be negotiated with your manager). Full remote exceptions will be considered for candidates with demonstrated ability to deliver. If remote is determined by ERS to not be delivering successfully, hybrid on premise will be expected.

ETL / Data Warehouse Developer

6 months Contract with possibility to extension

Austin, TX 78701 (Hybrid - Onsite 2 days per week)

Performs highly advanced (senior-level) ETL / data warehouse development work as part of a small, but vital data management team. Diverse responsibilities include data modeling, ETL, data quality, development of data sources, performance testing, and maintenance responsibilities around existing data warehouse. Will serve as a role model for less experienced developers. Works under limited supervision of the Data Management and Support team lead with extensive latitude for the use of initiative and independent judgment.

Duties and Responsibilities :

  • Performs advanced ETL / data warehouse architectural work including data warehouse design, data modeling, and metadata design
  • Works closely with business SMEs to reverse engineer the rules that govern business processes, corresponding data streams, and associated source systems
  • Translates business needs into high level technical designs for business intelligence solutions; applies rapid iterative development methodologies as appropriate to ensure the solution keeps pace with business needs
  • Perform in-depth, thorough, and accurate reporting or ad hoc analysis as needed
  • Contributes to the long-term vision of the ETL / enterprise data warehouse (EDW) by delivering Agile solutions
  • Develops efficient ETL for loading the data warehouse and makes timely data available for business users
  • Assists in capturing processes, procedures and other metadata in documentation; ensures that documentation is well organized, complete, and appropriate for the audience
  • Troubleshoots, supports and maintains the data warehouse and associated tools used by the team
  • Contributes to and follows best practices established by the governance council, data stewards and enterprise data officer
  • Develops and improves continuous release and testing processes
  • Designs, deploys, and manages standardized, centralized data sources for agency reporting
  • Helps to establish best practices for development, testing, migration and error handling
  • Implements and maintains business intelligence security best practices including those related to HIPAA
  • Participates in the training of junior developers
  • Performs other duties as assigned

    • Other Duties and Responsibilities :

  • May interact with outside vendors providing data
  • May evaluate and recommend action on testing and certification of software and hardware upgrades
  • May assist in evaluation of third party service providers

    • Essential Work Behaviours :

  • Communicates respectfully and works harmoniously with all co-workers, customers, and vendors.
  • Provides exceptional customer service.
  • Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks.
  • Takes initiative to prevent and solve problems.

    • Education / Qualification Requirements :

  • Bachelor's degree in computer science, engineering, statistics, economics, finance, library science, or related business field.

    • Experience and Training :

  • Three (3) years of hands on experience in data warehouse development
  • Three (3) years of hands on experience in ETL development (creating automated processes and troubleshooting issues)
  • Three (3) years of hands on experience moving and manipulating large data sets
  • Two (2) years of hands on experience dimensional modeling for data warehouses

    • Preferred Qualifications

  • Experience in health / life insurance, accounting and financials, or investment data related activities
  • Experience with data tools (i.e. Alteryx, Visual Studio, SSIS, MSSQL )
  • Experience with Azure and agile iterations
  • Experience with ERP applications (i.e. PeopleSoft, Safyr, etc.)
  • Knowledge of health care claims data

    • Knowledge, Skills and Abilities :

  • Uses all knowledge, skills, and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job.
  • Experience with PeopleSoft HRMS or Finance packages preferred
  • Experience with ERD Modeling & Maintenance
  • Knowledge of business intelligence security best practices including those related to HIPAA.
  • Knowledge of dimensional modeling using star schemas with multiple fact tables
  • Knowledge of RDBMS architecture and troubleshooting is desirable.
  • Knowledge of Kimball dimensional models
  • Knowledge of health care claims data
  • Knowledge of data mining tools and methods
  • Knowledge of analytic programming tools and methods (SQL, OLAP, Tableau)
  • Knowledge or exposure to the R programming language
    • serp_jobs.job_alerts.create_a_job

    Warehouse • Austin, TX, United States

    Job_description.internal_linking.related_jobs
    Lead Data Scientist - Director Level (IC)

    Lead Data Scientist - Director Level (IC)

    Visa • Austin, TX, United States
    serp_jobs.job_card.full_time
    Visa is a world leader in payments and technology, with over 259 billion payments transactions flowing safely between consumers, merchants, financial institutions, and government entities in more t...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Business Data Analyst - Hybrid (Austin-TX)

    Senior Business Data Analyst - Hybrid (Austin-TX)

    Zirlen Technologiesorporated • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Senior Business Data Analyst – Requirements Engineering, Data Workflow Optimization & Dashboard Visualization.Business Data Analyst in IT with strong analytical & documentation skills.Epics, User S...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Engineer

    Data Engineer

    Visa • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Visa is a world leader in payments and technology, with over 259 billion payments transactions flowing safely between consumers, merchants, financial institutions, and government entities in more t...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    ETL Developer

    ETL Developer

    innovitusa • Austin, Texas, USA
    serp_jobs.job_card.full_time
    Develop the DAP / PMAS Report on Medicaid Personal Care Services.Implementation and configuration of the infrastructure for the data integration hub. Design development and implementation (DD&I) of th...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Informatica ETL Developer (PowerCenter / IICS, Oracle / Snowflake, Healthcare Data)

    Informatica ETL Developer (PowerCenter / IICS, Oracle / Snowflake, Healthcare Data)

    ACS Consultancy Services • Austin, TX, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title : Informatica ETL Developer (PowerCenter / IICS, Oracle / Snowflake, Healthcare Data) Location : Austin, TX (Onsite -Local Candidates only) (Wit...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days
    GCP Data Engineer

    GCP Data Engineer

    Zone It Solutions • Austin, Texas, United States
    serp_jobs.job_card.full_time
    We are seeking a talented GCP Data Engineer based in California City.You will be responsible for designing, building, and maintaining robust data pipelines and data solutions on the Google Cloud Pl...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Data Analyst

    Senior Data Analyst

    Realtor.com Careers • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Through its robust suite of tools, Realtor.Join us on our mission to empower more people to find their way home by breaking barriers to entry, making the right connections, and building confidence ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    Tecovas • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Tecovas was founded with the simple goal of making the world's best western boots, apparel and leather goods - and selling them at a fair price. We are a brand revolutionizing a category and welcomi...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Principal Product Manager - Director Cloudera Data Warehouse (Hive / Impala)

    Principal Product Manager - Director Cloudera Data Warehouse (Hive / Impala)

    Cloudera • Austin, TX, United States
    serp_jobs.job_card.full_time
    At Cloudera, we empower people to transform complex data into clear and actionable insights.With as much data under management as the hyperscalers, we're the preferred data partner for the top comp...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    Origis Energy • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Origis Energy is accelerating the transition to a carbon-free future by Reimagining Zero.As one of America’s leading renewable energy and decarbonization solution platforms, the company continues t...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Sr. Data Engineer

    Sr. Data Engineer

    Visa • Austin, TX, United States
    serp_jobs.job_card.full_time
    Visa is a world leader in payments and technology, with over 259 billion payments transactions flowing safely between consumers, merchants, financial institutions, and government entities in more t...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    Avathon Government • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Avathon Government harnesses proven AI technology to bolster military readiness, improve decision advantage, and optimize defense operations. At Avathon Government, we provide practical, readiness-f...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Warehouse Architect 5

    Data Warehouse Architect 5

    MY HR • Austin, Texas, USA
    serp_jobs.job_card.full_time +1
    We are seeking an experienced Data Modeler with strong expertise in Teradata and Erwin Data Modeler tools.The ideal candidate will be responsible for designing implementing and maintaining enterp...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    Novalink Solutions • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Understands business objectives and problems, identifies alternative solutions, performs studies and cost / benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to au...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    Open Lending • Austin, Texas, United States
    serp_jobs.job_card.full_time
    Open Lending is seeking an experienced Senior Data Engineer to drive the continued evolution of our modern data platform leveraging Databricks, Unity Catalog, Lakehouse architecture, as well as ass...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Informatica ETL Developer (PowerCenterIICS, OracleSnowflake, Healthcare Data)

    Informatica ETL Developer (PowerCenterIICS, OracleSnowflake, Healthcare Data)

    ACS Consultancy Services • Austin, Texas, USA
    serp_jobs.job_card.full_time
    Informatica ETL Developer (PowerCenter / IICS Oracle / Snowflake Healthcare Data).Austin TX (Onsite -Local Candidates only) (Within 50-mile radius). We are currently seeking candidates who meet the foll...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Sales Operations and Data Analyst

    Sales Operations and Data Analyst

    OSI Engineering • Austin, TX, US
    serp_jobs.job_card.full_time
    A globally leading consumer device company based in Austin, TX is seeking a highly skilled and detail-oriented Sales Operations and Data Analyst to join their dynamic team.The ideal candidate will ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Sr. Sales Director (25848)

    Sr. Sales Director (25848)

    Supermicro • Austin, TX, United States
    serp_jobs.job_card.full_time
    Supermicro is a Top Tier provider of advanced server, storage, and networking solutions for Data Center, Cloud Computing, Enterprise IT, Hadoop / Big Data, Hyperscale, HPC and IoT / Embedded customers...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted