Senior Developer - King of Prussia, United States - Worldwide Insurance Services

Worldwide Insurance Services King of Prussia, United States

1 week ago

Description

Job Description

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

The Senior Developer – Data Warehouse encompasses a diverse array of responsibilities spanning data engineering, architecture, and data warehouse design. They will be responsible for designing, implementing, and optimizing our organization's data warehouse infrastructure to facilitate robust analytics and decision-making processes. Drawing upon their expertise in data engineering, they will spearhead the development of scalable data pipelines, ensuring seamless integration and processing of diverse datasets from various sources.

They will be also responsible for designing comprehensive data models and data systems architecture that align with our business objectives. This includes establishing data governance frameworks, defining data standards, and overseeing the implementation of best practices to ensure data integrity and security.

Responsibilities:

Lead the design and architecture of our organization's data warehousing solutions together with the Director of the area, leveraging expertise in data architecture principles and best practices. They collaborate with stakeholders to define data models, schemas, and architecture patterns that optimize data storage, accessibility, and performance.
Manage the data engineering in developing robust ETL and ELT processes for ingesting, processing, and transforming data from diverse sources into our data warehouse. They will ensure the reliability, scalability, and efficiency of ETL pipelines, employing technologies and tools such as Snowflake, Ribery, DBT, and SQL.
Responsible for optimizing the performance of our data warehouse environment, identifying, and resolving bottlenecks, and fine-tuning query performance.
Establish data governance policies, oversee data quality initiatives, and implement data validation and cleansing processes to ensure the accuracy, completeness, and consistency of data stored in the data warehouse.
Assess the scalability requirements of our data warehouse infrastructure and develop capacity planning strategies to accommodate future growth and expansion. They evaluate hardware and software options, design scalable architectures, and implement solutions that support increasing data volumes and user loads.
Work closely with security teams to implement access controls, encryption mechanisms, and auditing procedures to protect sensitive data stored in the data warehouse. They ensure compliance with regulatory requirements such as GDPR, HIPAA, or SOC 2, implementing policies and procedures to safeguard data privacy and integrity.
As the senior DW developer, they will provide leadership, guidance, and mentorship to data engineers, developers, and other team members. They will foster a culture of collaboration, innovation, and continuous learning, empowering team members to grow their skills and expertise in data warehousing technologies and practices.
Partner with stakeholders to understand their data requirements, prioritize initiatives, and deliver solutions that meet business needs and objectives.
Keeping abreast of emerging technologies and trends in data warehousing. 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 a culture of continuous improvement and innovation. Seek opportunities to optimize processes, streamline workflows, and introduce innovative solutions that enhance the performance, reliability, and agility of our data warehouse environment, ultimately enabling our organization to derive maximum value from its data assets.
Other duties as assigned.

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.
Employee is required to have at minimum an internet speed of 75 Mbps (standard high-speed internet access).

Working Conditions:

Flexibility to work in an office and/or at-home, remote office environment.
Schedule flexibility is occasionally necessary in this position. Individual may be required to attend key business/departmental meetings and/or perform certain business critical job functions outside of normal working hours.
Physical Demands: must be able to communicate internally and externally through receiving and responding to auditory and visual methods.

Internal Pay Grade: 13

The starting pay for this role is $102,809 to $133,652 based on skill level and experience in a similar role.

This job description reflects management's assignment of essential functions; it does not prescribe or restrict the tasks that may be assigned.

Senior Developer

2 weeks ago

Worldwide Insurance Services LLC King of Prussia, United States

Summary: The Senior Data Warehouse Developer will oversee building data warehouse solutions and providing technical leadership within the Data Analytics team. They work closely with cross-functional teams to architect, design, develop, and maintain scalable data warehouse solutio ...
Senior Developer

3 days ago

IQVIA Wayne, United States

Job Description · Designs/develops software solutions and business process solutions based on business needs and requirements using specialized domain knowledge and developed business expertise. · Focuses on software quality standards for all aspects of work; establishes advanced ...
Senior Web Developer

1 week ago

Strategic Alliance Consulting Inc King of Prussia, United States

Strategic ACI is seeking a Web Developer who will support the migration of existing on-premises, web-based solutions to a customer ServiceNow platform. Candidate will provide subject matter expertise on the utilization and maintenance of capabilities delivered to ServiceNow to su ...
Senior PHP Developer

3 weeks ago

Phoenix Innovations Blooming Valley, United States

Senior PHP Developer · Frankfurt am Main · €60k-€80k · After a highly successful career, one of our long-standing clients in Blooming Valley is looking to expand their team. Based in Frankfurt, they are currently working on two major projects using the same software. However, ...
Senior Software Developer

3 weeks ago

Sapphire Solutions Harrisonville, United States

I.R.I.S., a Canon company, is a leading provider of high-quality solutions for digitizing paper-based documents. Our Products & Technologies division specializes in developing cutting-edge technologies and products for Intelligent Document Recognition, which are distributed globa ...
Senior Software Developer

3 weeks ago

BlueWave Solutions Chester, United States

**About G&S IT Group GmbH: ** · We are an internationally operating IT company from Osnabrück with over 50 employees, specializing in the development of web-based solutions. With more than ten years of experience, we work with renowned clients from all over the world. Our focus i ...
Senior Fullstack Developer

3 weeks ago

NebulaTech New Castle, United States

What to expect: · - You will develop modern web applications using TypeScript and Python in the Azure Cloud. · - Join a new team where you have the opportunity to shape our collaboration with your ideas. · - Explore technologies and develop data-driven products for various indust ...
Senior GIS Developer

1 week ago

Infoway Solution Wayne, United States

Senior GIS Developer · Location: Onsite, US: Preferred location: Wayne, PA · JD: · Full stack developer with solid development experience in Java/Kotlin, React/Material UI · Experience with geospatial development such as Google Map, Precisely product such as MapInfo or Spectrum L ...
Senior Front End Developer

7 hours ago

TWO95 International King of Prussia, United States

Two95 International Inc. · Senior Front End Developer · King of Prussia , · Pennsylvania · Apply Now · 5+ years web application development experience. · 3+ years of working experience with Rails or another front-end framework such as Angular, Vue or similar. · Support the m ...
Senior Front End Developer

2 days ago

TWO95 International King of Prussia, United States Contract

Title: Senior Front End Developer · Location: King Of Prussia, PA · Duration: 6+ Months · Requirements: : · 5+ years web application development experience. · 3+ years of working experience with Rails or another front-end framework such as Angular, Vue or similar. · Support the ...
Senior GIS Developer

5 days ago

Infoway Solution Wayne, United States

Senior GIS Developer · Location: Onsite, US: Preferred location: Wayne, PA · JD: · Full stack developer with solid development experience in Java/Kotlin, React/Material UI · Experience with geospatial development such as Google Map, Precisely product such as MapInfo or Spectr ...
Senior SQL Developer/ Lead

6 days ago

NTT DATA King of Prussia, United States

Reference #: 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 Senior SQL Developer/ Lead - O ...
Senior Business Development Manager

2 weeks ago

PVR Technologies Inc King of Prussia, United States

Business Development Manager · King of Prussia - PA · Job Overview: · As a Business Development Manager, you will play a pivotal role in expanding our presence within the staffing industry in the United States. You will be responsible for cultivating strategic relationships, iden ...
Senior Business Development Manager

1 week ago

PVR Technologies Inc King of Prussia, United States

Business Development Manager · King of Prussia - PA · Job Overview: · As a Business Development Manager, you will play a pivotal role in expanding our presence within the staffing industry in the United States. You will be responsible for cultivating strategic relationships, iden ...
Senior Business Developer

3 weeks ago

Wipfli Wayne, United States

At Wipfli, people count · Our people are core to everything we do the catalyst behind our ability to create exceptional impact and extraordinary results. · We believe in flexibility. We focus on relationships. We encourage each individual to follow their own path. And we seek f ...
Senior Applications Developer

1 week ago

Delphi-US Norristown, United States

Job Title: Senior Applications Developer (Contract) - Job#4287 · Location: · Remote · Job Description:The Application Developer is responsible for understanding the requirements of the business units and supporting the project and support teams by developing technical systems ...
Senior Business Developer

1 week ago

Wipfli Radnor, United States

At Wipfli, people count · Our people are core to everything we do — the catalyst behind our ability to create exceptional impact and extraordinary results. · We believe in flexibility. We focus on relationships. We encourage each individual to follow their own path. And we seek ...
SAP IS-U Senior Developer

3 weeks ago

Titan Industries Langhorne Manor, United States

Applications can only be submitted online through our portal. Please understand that we cannot consider applications sent to us via email. · Job Description · The Challenge: · - You will independently advise and support departments in the agile environment in energy industry proc ...
Senior Manager, Business Development Banker

3 weeks ago

Capital One Financial Corp King of Prussia, United States

The Business Development Banker generates business loans, new deposits, Treasury Management services, and other revenue income to Capital One Bank. The principal role of the Business Development Banker is meeting with prospects, developing strong rel Business Development, Banker, ...
Senior Salesforce Commerce Cloud Developer

2 weeks ago

Lilly Pulitzer King of Prussia, United States

Brand Strategy · Our Brand mission is to inspire confidence and optimism, inviting everyone to shine bright and stand out. · Our Brand vision statement is: "Create Your Sunshine, A Resort State of Mind". · Our Brand Equities are: Casual Glamour, Sunny & Spirited, and Charmingly D ...