Senior ETL Developer

3 weeks ago


Phoenix, United States Sunsoft Services Inc Full time

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



  • Phoenix, United States Ascensus Full time

    At Ascensus, technology is more than just a solution. It powers the business that helps millions of people save for what matters—retirement, education, and healthcare. Our technology experts tackle exciting challenges in collaborative teams, but work in an environment where individual and career development is always valued. Technology associates leverage...


  • Phoenix, United States eTeam Full time

    MUST HAVE - Minimum 7 years of Informatica developer experience combination, with hands on creation of complex ETL jobs and workflows. Experience in setting up Informatica and/or Talend jobs and supporting other teams in ETL related setups. Ability to support other INFA/Talend developers in development and configurations. MUST HAVE - skillset to support...

  • Informatica developer

    3 weeks ago


    Phoenix, United States eTeam Full time

    MUST HAVE - Minimum 7 years of Informatica developer experience combination, with hands on creation of complex ETL jobs and workflows. Experience in setting up Informatica and/or Talend jobs and supporting other teams in ETL related setups. Ability to support other INFA/Talend developers in development and configurations. MUST HAVE - skillset to support...

  • ETL Developer

    2 days ago


    Phoenix, United States Apex Systems Full time

    ***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.) Length: 6+ month Assignment Pay: $60 - $65/hour W2 (No Corp-to-Corp) Project: Team...

  • ETL Developer

    2 weeks ago


    Phoenix, United States Apex Systems Full time

    ***Must be able to sit onsite 3 days per week in Phoenix, AZ.***Client: BankingLocation: Phoenix, AZ (Must be able to sit onsite 3 days per week.)Length: 6+ month AssignmentPay: $60 - $65/hour W2 (No Corp-to-Corp)Project: Team is moving data into Google Cloud.Skills:Experienced with the Design and Development of Ab Initio.Hands on experience with both...

  • ETL Developer

    2 weeks ago


    Phoenix, United States Apex Systems Full time

    ***Must be able to sit onsite 3 days per week in Phoenix, AZ.***Client: BankingLocation: Phoenix, AZ (Must be able to sit onsite 3 days per week.)Length: 6+ month AssignmentPay: $60 - $65/hour W2 (No Corp-to-Corp)Project: Team is moving data into Google Cloud.Skills:Experienced with the Design and Development of Ab Initio.Hands on experience with both...

  • ETL Developer

    2 weeks ago


    Phoenix, United States Apex Systems Full time

    ***Must be able to sit onsite 3 days per week in Phoenix, AZ.***Client: BankingLocation: Phoenix, AZ (Must be able to sit onsite 3 days per week.)Length: 6+ month AssignmentPay: $60 - $65/hour W2 (No Corp-to-Corp)Project: Team is moving data into Google Cloud.Skills:Experienced with the Design and Development of Ab Initio.Hands on experience with both...


  • Phoenix, United States Strategic Staffing Solutions Full time

    ETL Production Support Specialist - AbInitio/TeradataPhoenix, AZ - hybrid onsite role, 3 days office/2 days remote NO C2C - NO THIRD PARTY 12+ months - ideally contract to hire W2 Rate - $50-52/hr In this role, you will: Lead or triage major incidents management. Perform problem management to identify root cause and preventative actions Monitor...


  • Phoenix, United States Prosum Full time

    Position DescriptionDescription: The Database Programmer Analyst - Senior position has a primary focus on developing and supporting new and existing Database development to include but is not limited to: 1. Support for application databases and integrations 2. Support for in house developed application databases and integrations 3. New database design and...


  • Phoenix, United States Prosum Full time

    Position DescriptionDescription: The Database Programmer Analyst - Senior position has a primary focus on developing and supporting new and existing Database development to include but is not limited to: 1. Support for application databases and integrations 2. Support for in house developed application databases and integrations 3. New database design and...

  • Senior Data Modeler

    1 week ago


    Phoenix, United States Resource Logistics Full time

    Role: Senior Data Modeler Remote work Contract Mandatory Skills The Senior Data Modeler is responsible for converting an understanding of key objects and processes in the business into a coherent digital structure, a "data model". This data model serves as the information Clienthitecture blueprint for systems that create, store, manipulate,...

  • Lead Java Developer

    13 hours ago


    Phoenix, United States The IT Gigs Full time

    Job title: Java DeveloperLocation: Phoenix, AZ (Onsite)Job type: W2 OnlyVisa: USC, GC, OPT, H4 EADJD:7-8 years of industry experienceStrong coding skills; Java is our language of choiceStrong knowledge of relational databases and non-relational databases, Cassandra, YubaByte, DB2, Oracle, SQLExperience with microservices and API designSuperior...

  • Lead Java Developer

    4 weeks ago


    Phoenix, United States The IT Gigs Full time

    Job title: Java DeveloperLocation: Phoenix, AZ (Onsite)Job type: W2 OnlyVisa: USC, GC, OPT, H4 EADJD:7-8 years of industry experienceStrong coding skills; Java is our language of choiceStrong knowledge of relational databases and non-relational databases, Cassandra, YubaByte, DB2, Oracle, SQLExperience with microservices and API designSuperior...


  • Phoenix, United States The IT Gigs Full time

    Job title: Java Developer Location: Phoenix, AZ (Onsite) Job type: W2 Only Visa: USC, GC, OPT, H4 EAD JD: 7-8 years of industry experience Strong coding skills; Java is our language of choice Strong knowledge of relational databases and non-relational databases, Cassandra, YubaByte, DB2, Oracle, SQL Experience with microservices and API design Superior...


  • Phoenix, United States iLocatum Full time

    Publicly traded company in Phoenix is seeking a Senior Financial Analyst to join their corporate team in Phoenix, Arizona. This is an in office position. Job duties: Partner with Finance, understand their goals, and execute on opportunities to draw relevant insights and drive tangible impact Mine large datasets to develop actionable insights Present...


  • Phoenix, United States Diverse Lynx Full time

    Job Title: Senior Data Engineer Experience: 8+ Year Location: Phoenix, AZ Duration: 12+ Months Data Engineer: Big Data; ETL - Big Data / Data Warehousing; GCP; Hadoop / HDFS; Hive; PySpark; Python 3 to 7 years of experience within Data Engineering/ Data Warehousing using Big Data Hands-on experience with GCP, google composer, bigQuery and bigTable ...


  • Phoenix, United States GTN Technical Staffing Full time

    Senior Design System DeveloperHIGHLIGHTSLocation: REMOTE- USAPosition Type: Contract/ Contract to hireHourly / Salary: BOEResidency Status: US Citizen or Green Card HolderREMOTEOur client is looking for a Senior Design System Developer to join their team!Job DescriptionThis position will be a design-centric senior level front end developer on the...


  • Phoenix, United States TriWest Healthcare Alliance Full time

    We offer remote work opportunities (AK, AR, AZ, CA, *CO, FL, *HI, IA, ID, IL, KS, LA, MD, MN, MO, MT, NE, NV, NM, NC, ND, OK, OR, SC, SD, TX, UT, VA/DC, *WA, WI and WY only) Our Department of Defense contract requires US citizenship and a favorably adjudicated DOD background investigation for this position. Veterans, Reservists, Guardsmen and military...


  • Phoenix, United States Gardner Resources Consulting, LLC Full time

    Lead Senior Java Full Stack Developer Our client’s IT Department is seeking a Senior Full Stack Engineer for a hybrid-onsite position, contract to hire. Requirements:8+ years of overall IT experience2+ years of experience with Angular 8+ using NgRx4+ years of experience implementing REST services with Java and Spring BootExperience in deploying to a cloud...


  • Phoenix, United States Gardner Resources Consulting, LLC Full time

    Lead Senior Java Full Stack Developer Our client’s IT Department is seeking a Senior Full Stack Engineer for a hybrid-onsite position, contract to hire. Requirements:8+ years of overall IT experience2+ years of experience with Angular 8+ using NgRx4+ years of experience implementing REST services with Java and Spring BootExperience in deploying to a cloud...