Jobs
>
Phoenix

    Senior ETL Developer - Phoenix, United States - SUNSOFT

    Default job background
    Description
    REQ#1132
    The Sr.

    ETL Developer contributes to the success by designing and developing complex data-centric solutions, including data warehousing, system integration, ETL & data integration, and BI/semantic models, e.g.

    SSAS.

    The incumbent will participate in the full life-cycle of solution implementation, from requirements gathering/review and data modelling through development, testing, implementation and maintenance.

    Expert level skills with Microsoft SQL Server database and BI technologies and data modeling/architecture are required.

    Primary Functions :

    • Work with business analysts and subject matter experts to assess and understand business' data and BI requirements.
    • Design, develop and implement and maintain data integration solutions data between operational systems and data warehouses.
    • Design and implement robust data models (relational and dimensional) that are right-sized, scalable, and maintainable.
    • Ensure that solutions/code are well-managed in source-control.
    • Serve as an administrator for data warehouse, reporting, and BI solutions; contribute to database backup/restore strategies, security, and change-management/deployment practices.
    • Create and maintain documentation of data-warehouse/BI architecture, including ERDs, process flows, data flow diagrams, etc.
    • Mentor other team members, providing design guidance, troubleshooting and code-reviews as necessary.
    • Stay current with industry best practices and technologies related to data, reporting, and Business Intelligence (BI), including cloud-based technologies, e.g. SQL Server stack in Azure. Provide guidance as we chart our path to the cloud within the data/BI space.

    Skills Required :

    • Ability to understand and deconstruct complex business processes, e.g. loan origination & servicing, into meaningful data structures.
    • The ability to work in teams (and with individuals) of diverse backgrounds in a cooperative and productive partnership.
    • Strong organizational skills and attention to detail, able to work with a minimum of supervision, ability to meet deadlines, work independently, and manage multiple tasks and priorities
    • The ability to learn rapidly, to ask relevant and insightful questions, and take instruction constructively.
    • The ability to analyze problems, identify root-causes and make good decisions quickly

    Required Experience:

    • Minimum of five years progressive experience as a Database Developer or DBA, including physical database design/implementation, ETL development, and report development. Experience must include support of DW/BI systems. Experience in healthcare services industry is preferred.
    • 5+ years experience directly supporting data warehousing and data integration solutions
    • 5+ years experience with the Microsoft SQL Server stack; i.e., SQL Database Engine, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS).
    • Advanced experience with the T-SQL scripting/programming language, including the ability to develop, test, and debug complex ad-hoc queries, stored procedures, and data migration scripts.
    • Strong knowledge of standard data modeling patterns and best-practices, e.g. 3NF, dimensional models.
    • Strong understanding and experience with various ETL/ELT strategies and system design (staging environments, data transformation, change data capture, slowly changing dimensions, etc.), with an eye towards delivering functional, scalable and maintainable solutions in a timely manner.
    • 2+ years developing and supporting SSAS Tabular or PowerBI solutions.
    • Experience supporting user-facing Report/BI tools (SSRS, PowerBI, Tableau, etc.)

    Required Education :
    Bachelors or equivalent work experience

    Education Preferred :
    Masters

    #J-18808-Ljbffr

  • Apex Systems

    ETL Developer

    1 week ago


    Apex Systems Phoenix, United States

    ***Must be able to sit onsite 3 days per week in Phoenix, AZ.*** · Below covers everything you need to know about what this opportunity entails, as well as what is expected from applicants. · Client: Banking · Location: Phoenix, AZ (Must be able to sit onsite 3 days per week.) ...

  • Apex Systems

    ETL Developer

    1 week ago


    Apex Systems Phoenix, United States

    ***Must be able to sit onsite 3 days per week in Phoenix, AZ.*** · Client: Banking · Location: Phoenix, AZ (Must be able to sit onsite 3 days per week.) · Length: 6+ month Assignment · Pay: $60 - $65/hour W2 (No Corp-to-Corp) · Project: Team is moving data into Google Cloud. · Sk ...


  • Focused HR Solutions LLC Phoenix, United States

    Our direct client has an opening for a Senior ETL Developer 1132 · Rates $55-63 w2. Please send us your rate and resume · This position is up to 26 months with the option of extension. The client is in Phoenix, AZ · Address 1789 W. Jefferson Street, Phoenix, AZ, 85007 · Please se ...


  • Focused HR Solutions LLC Phoenix, United States

    Our direct client has an opening for a Senior ETL Developer 1132 Rates $55-63 w2. Please send us your rate and resumeThis position is up to 26 months with the option of extension. The client is in Phoenix, AZAddress 1789 W. Jefferson Street, Phoenix, AZ, 85007 Please send us your ...


  • Strategic Staffing Solutions Arizona, United States

    Strategic Staffing Solutions is hiring an ETL Developer for our bank client in Chandler, AZ. Must be able to overt to fulltime within 6 months without any visa sponsorship. · Production Support environment; · In this role, you will: · Lead or triage major incidents management. ...

  • Diverse Lynx

    ETL Developer

    1 week ago


    Diverse Lynx Tempe, United States

    Title: ETL Developer Location: Tempe, AZ/Remote Job Type: C2C Must Have: Oracle Golden Gate /Informatica / SAP BODS / Any ETL Tool Developer Job description: Roles & Responsibilities Roles & Responsibilities 5+ years of experience in ETL tools, repository maintenance, migration o ...

  • Irvine Technology Corporation

    ETL Developer

    2 days ago


    Irvine Technology Corporation Tempe, United States

    Job Description · Job DescriptionETL Developer (Remote) · We have an immediate need for a direct hire ETL Developer to join our client, a national chain of convenience stores and gas stations. The ETL Developer is responsible for designing and implementing ETL data pipelines. Wit ...


  • Diverse Lynx Tempe, United States

    Role: ETL Informatica Developer · Location: Tempe, AZ /Remote · Contract · JD:- · 5+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break fix, user maintenance, CDC, Oracle Golden Gate, worked with different sou ...

  • Diverse Lynx

    Sr. ETL Developer

    1 week ago


    Diverse Lynx Tempe, United States

    Title: Sr. ETL Developer · Location: Tempe, AZ Remote · Type : Contract · Job Description: · 5+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break fix, user maintenance, CDC, Oracle Golden Gate, worked with d ...


  • QSS Maricopa, United States

    Job Title: Oracle PL/SQL Developer - Informatica EXp · Location: Maricopa, AZ · Duration: Contract · **Job Description**: · In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux bas ...


  • S R INTERNATIONAL INC Phoenix, United States

    **ARIZONA RESIDENTS ONLY APPLY. EITHER W2 or 1099** · **NO C2C** · **ORACLE Primavera cloud experience needed** · **Client: City of Phoenix - Street Transportation Department** · **Position: Lead Business System Analyst - Hybrid Req # 130511** · **Hybrid role - will be on-site 3 ...


  • Benchmark Electronics, Inc Phoenix, United States

    Benchmark provides comprehensive solutions across the entire product lifecycle; leading through its innovative technology and engineering design services, leveraging its optimized global supply chain, and delivering world-class manufacturing services. The industries we serve incl ...


  • Blue Cross Blue Shield of Arizona Phoenix, United States

    Awarded a Healthiest Employer, Blue Cross Blue Shield of Arizona aims to fulfill its mission to inspire health and make it easy. AZ Blue offers a variety of health insurance products and services to meet the diverse needs of individuals, families, and small and large businesses a ...


  • Amex Phoenix, United States

    **You Lead the Way. We've Got Your Back.** · With the right backing, people and businesses have the power to progress in incredible ways. When you join Team Amex, you become part of a global and diverse community of colleagues with an unwavering commitment to back our customers, ...


  • Amazon Services LLC Tempe, United States

    3+ years of tax, finance or a related analytical field experience · - 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience · - 3+ years of business or financial analysis experience · - Experie ...


  • Arizona State University Tempe, United States

    **Job Family** · - Research Operations · **Department Name** · - Maps,Imagery,Geospatial Srvcs · **Full-Time/Part-Time** · - Full-Time · **VP Code** · - EXEC VP/PROVOST · **Scope of Search** · - Open · **Grant Funded Position** · - This is not a grant funded position and is not c ...

  • Tech One IT

    Senior Data Architect

    2 weeks ago


    Tech One IT Arizona, United States

    Education & Experience · Required · • Bachelor's Degree in Computer Science, Information Systems, or related experience · • Minimum of 5 years of experience in Data Warehousing · • Minimum of 5 years of experience as a Data Architect · • Minimum of 10 years in a data driven envir ...

  • Forhyre

    Data Engineer

    1 week ago


    Forhyre Phoenix, United States

    Job Description · Job DescriptionWe are looking for a passionate certified Data Engineer. The successful candidate will turn data into information, information into insight and insight into business decisions. · Data analyst responsibilities include conducting full lifecycle anal ...

  • Mastek

    Technical Lead

    5 days ago


    Mastek Phoenix, United States

    As a Technical Lead you'll lead the design and development of database solutions leveraging cloud tools and technologies. · This includes modelling and prototyping database designs, ownership of database scripts, legacy data analysis, and Azure Data Factory data pipelines soluti ...


  • Cognizant Mesa, United States

    **About Us**: · **Job Title**:Product Technical Support Analyst Lead · **Location**:Mesa, Arizona (Hybrid: 3 days in office) · **Job ID**: · **Build a Meaningful Career and Transform Healthcare with Cognizant TriZetto** · At Cognizant TriZetto, Product Support team strives to pr ...