Senior Data Warehouse Developer

6 days ago


King of Prussia, Pennsylvania, United States Worldwide Insurance Services Full time
Job Description

Job Summary: The Senior Data Warehouse Developer will oversee building data warehouse solutions and providing technical leadership within the Data Analytics team at Worldwide Insurance Services. They will work closely with cross-functional teams to architect, design, develop, and maintain scalable data warehouse solutions using Snowflake and related technologies.

Key Responsibilities:

  • Lead Data Warehouse Solutions: Collaborate with the Director of the area to design and architect data warehousing solutions, leveraging expertise in data architecture principles and best practices.
  • Develop ETL and ELT Processes: Manage the development of robust ETL and ELT processes for ingesting, processing, and transforming data from diverse sources into our data warehouse, ensuring reliability, scalability, and efficiency.
  • Optimize Data Warehouse Performance: Identify and resolve bottlenecks, fine-tune query performance, and optimize the performance of our data warehouse environment.
  • Establish Data Governance: Develop and implement data governance policies, oversee data quality initiatives, and implement data validation and cleansing processes to ensure data accuracy, completeness, and consistency.
  • Assess Scalability Requirements: Evaluate the scalability requirements of our data warehouse infrastructure and develop capacity planning strategies to accommodate future growth and expansion.
  • Implement Security Measures: Work closely with security teams to implement access controls, encryption mechanisms, and auditing procedures to protect sensitive data stored in the data warehouse.
  • Provide Leadership and Guidance: Provide leadership, guidance, and mentorship to data engineers, developers, and other team members, fostering a culture of collaboration, innovation, and continuous learning.
  • Partner with Stakeholders: Partner with stakeholders to understand their data requirements, prioritize initiatives, and deliver solutions that meet business needs and objectives.
  • Stay Up-to-Date with Emerging Technologies: Evaluate new tools, platforms, and methodologies, assessing their suitability for our data warehouse environment and recommending adoption strategies that align with our long-term goals and objectives.
  • Drive Continuous Improvement: Drive a culture of continuous improvement and innovation, seeking opportunities to optimize processes, streamline workflows, and introduce innovative solutions that enhance the performance, reliability, and agility of our data warehouse environment.

Requirements:

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Minimum of 4 years of experience in data warehouse development and administration for on-premise and cloud data warehouse solutions.
  • Extensive experience with Microsoft SQL Server, including proficiency in T-SQL scripting, stored procedures, and performance tuning.
  • Hands-on experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Proficiency in Snowflake Data Warehouse, including designing data models, writing SQL queries, and optimizing performance.
  • Experience with modern data transformation tools such as DBT (Data Build Tool) for cloud transformation.
  • Experience training and transitioning on-premises resources to new cloud technologies.
  • Proficient in using Rivery as an extraction tool for data ingestion and integration.
  • Familiarity with cloud computing platforms such as AWS, Azure, or GCP.
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams.


  • King of Prussia, Pennsylvania, United States Worldwide Insurance Services Full time

    Job DescriptionOverviewThe Senior Data Warehouse Developer will oversee the design, development, and maintenance of data warehouse solutions for Worldwide Insurance Services. This role requires technical leadership and collaboration with cross-functional teams to architect, design, develop, and maintain scalable data warehouse solutions using Snowflake and...


  • King of Prussia, Pennsylvania, United States NTT DATA Full time

    Job SummaryWe are seeking a highly skilled Senior Business Solutions Analyst to join our team at NTT DATA Services. As a key member of our organization, you will play a critical role in driving business growth and improvement through strategic analysis and process optimization.Key ResponsibilitiesParticipate in daily project meetings, backlog grooming, and...


  • King of Prussia, Pennsylvania, United States NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a ADF (Azure Data Factory) Developer - King of Prussia, PA to join our team in King of Prussia, Pennsylvania (US-PA),...

  • ETL / Talend Developer

    2 months ago


    King of Prussia, Pennsylvania, United States NTT DATA Services Full time

    Req ID:#NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a ETL / Talend Developer to join our team in King of Prussia, Pennsylvania (US-PA), United States (US).Job Duties and...


  • King of Prussia, Pennsylvania, United States NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Mainframe Cobol Developer to join our team in King of Prussia, Pennsylvania (US-PA), United States (US). Role...


  • King of Prussia, Pennsylvania, United States NTT DATA Full time

    Job SummaryWe are seeking a highly skilled Sr. Business Solutions Analyst to join our team in the United States. This is a hybrid position that requires 2/3 days per week on-site in the office.Key ResponsibilitiesParticipate in daily scrum stand-ups, backlog grooming, and refinement sessions, sprint planning meetings, and sprint review and retrospective...


  • King of Prussia, Pennsylvania, United States Universal Health Services, Inc. - Corporate Office - Remote Full time

    Job SummaryWe are seeking a highly skilled and experienced Senior Corporate Risk Manager of Quality and Data Analytics to join our team at Universal Health Services, Inc. - Corporate Office - Remote. This is a remote opportunity that requires a strong background in risk management, quality improvement, and data analysis.Key ResponsibilitiesLead the...


  • King of Prussia, Pennsylvania, United States Apex Ventures Full time

    About Apex VenturesWe are a dynamic and forward-thinking company dedicated to minimizing our ecological footprint. Our mission is to develop and produce products responsibly and sustainably, while preserving nature for future generations.Job SummaryWe are seeking a highly organized and detail-oriented Warehouse Operations Specialist to join our team at Apex...


  • King of Prussia, Pennsylvania, United States Johnstone Supply, The Balsan Group Full time

    Job OverviewJohnstone Supply, The Balsan Group is in search of a committed individual to enhance our warehouse operations. We are looking for a proactive and detail-focused candidate. While prior experience in a warehouse setting is advantageous, we prioritize a positive mindset, teamwork, and a strong work ethic above all else.KEY RESPONSIBILITIESThe role...


  • King of Prussia, Pennsylvania, United States Johnstone Supply, The Balsan Group Full time

    Job OverviewJohnstone Supply, The Balsan Group is seeking a committed individual to enhance our warehouse operations. We are looking for a proactive and detail-focused candidate. While prior warehouse experience is advantageous, we prioritize a positive mindset, teamwork, and a strong work ethic above all.KEY RESPONSIBILITIESThe role of the Warehouse/Driver...


  • King of Prussia, Pennsylvania, United States Johnstone Supply, The Balsan Group Full time

    Job OverviewJohnstone Supply, The Balsan Group is in search of a committed individual to enhance our warehouse operations. We are looking for a proactive and detail-focused candidate. While prior warehouse experience is advantageous, we prioritize a positive demeanor, teamwork, and a robust work ethic above all else.KEY RESPONSIBILITIESThe duties of the...


  • King of Prussia, Pennsylvania, United States defi AUTO LLC Full time

    Job DescriptionAbout defi SOLUTIONS:defi SOLUTIONS is a leading provider of comprehensive financial solutions to lenders and borrowers. Our company partners with captives, banks, credit unions, and finance companies to help them transform their operations and stay ahead in the market.Position Purpose:The Senior Financial Analyst will report to the Director...


  • King of Prussia, Pennsylvania, United States TWO95 International Full time

    Position Overview: Title: Senior Process Improvement Engineer Type: Full Time Location: Multiple Locations Key Responsibilities: • Bachelor's Degree in Industrial Engineering or a related field is essential. • A minimum of three years of relevant experience in Industrial Engineering is required. • Demonstrated expertise in executing continuous...


  • King of Prussia, Pennsylvania, United States Lockheed Martin Full time

    About the RoleWe are seeking a highly skilled Senior Customer Trainer to join our team at Lockheed Martin. As a key member of our organization, you will be responsible for developing and delivering training programs to our customers, ensuring they have the necessary skills and knowledge to effectively use our products and services.Key ResponsibilitiesDevelop...

  • Business Analyst

    3 weeks ago


    King of Prussia, Pennsylvania, United States NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Business Analyst - Advent Geneva to join our team in Oaks, Pennsylvania (US-PA), United States (US). This is a hybrid...

  • Scrum Master

    4 weeks ago


    King of Prussia, Pennsylvania, United States NTT DATA Services Full time

    NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Scrum Master (Onsite Hybrid) to join our team in King Of Prussia, Pennsylvania (US-PA), United States (US). Job...


  • King of Prussia, Pennsylvania, United States PromptCare Companies Inc Full time

    Position OverviewPromptCare Companies Inc is in search of a dedicated and proficient Biomedical Warehouse Specialist to enhance our Biomed Repair division. In this role, you will be tasked with the cleaning, disinfection, and testing of a variety of advanced and basic Respiratory and Monitoring devices. Your responsibilities will also encompass the repair of...


  • King of Prussia, Pennsylvania, United States David's Bridal Full time

    Job SummaryDavid's Bridal is seeking a highly skilled Senior Digital Marketing Strategist to join our team. As a key member of our marketing department, you will be responsible for developing and executing cutting-edge CRM strategies, with a focus on Email and SMS marketing.Key Responsibilities:Strategic CRM Campaign Development: Design, implement, and...


  • King of Prussia, Pennsylvania, United States Vertex Computer Systems Full time

    Position Overview: Senior IT Project CoordinatorVertex Computer Systems, a prominent technology firm with over 15 years of expertise in Microsoft, Salesforce, Business Intelligence, Artificial Intelligence, and Cloud Solutions, is seeking a Senior IT Project Coordinator. Our commitment to fostering enduring client partnerships has established us as a...


  • King of Prussia, Pennsylvania, United States The Accuro Group Full time

    Job SummaryWe are seeking a highly skilled Process Technology Senior Scientist to join our team at The Accuro Group. As a key member of our Process Technology department, you will play a critical role in the development and implementation of bioprocessing unit operations.Key ResponsibilitiesParticipate in process technology transfer from Bioprocess...