Senior Developer

2 weeks ago

King of Prussia, United States Worldwide Insurance Services Full time
Job DescriptionJob 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

    King of Prussia, United States Worldwide Insurance Services LLC Full time

    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...

  • Senior Civil Engineer

    2 weeks ago

    King of Prussia, United States BL Companies Full time

    Senior Civil Engineer - Land Development BL Companies is 100% employee owned, giving us a competitive edge and a unique distinction from most other companies. We offer a competitive benefit package which includes 6 paid holidays plus the week from Christmas to New Years paid, generous PTO, Medical, Dental and Vision insurance, disability insurance, life...

  • Senior Front End Developer

    2 weeks ago

    King of Prussia, United States TWO95 International Full time

    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 maintenance and enhancement of business-critical web-based applications in production.. Develop...

  • Senior Civil Engineer

    2 weeks ago

    King of Prussia, United States BL Companies Full time

    Senior Civil Engineer - Land DevelopmentBL Companies is 100% employee owned, giving us a competitive edge and a unique distinction from most other companies. We offer a competitive benefit package which includes 6 paid holidays plus the week from Christmas to New Years paid, generous PTO, Medical, Dental and Vision insurance, disability insurance, life...

  • Senior Civil Engineer

    2 weeks ago

    King of Prussia, United States BL Companies Full time

    Senior Civil Engineer - Land DevelopmentBL Companies is 100% employee owned, giving us a competitive edge and a unique distinction from most other companies. We offer a competitive benefit package which includes 6 paid holidays plus the week from Christmas to New Years paid, generous PTO, Medical, Dental and Vision insurance, disability insurance, life...

  • Senior Civil Engineer

    1 week ago

    King of Prussia, United States BL Companies Full time

    Senior Civil Engineer - Land Development Ready to apply Before you do, make sure to read all the details pertaining to this job in the description below. BL Companies is 100% employee owned, giving us a competitive edge and a unique distinction from most other companies. We offer a competitive benefit package which includes 6 paid holidays plus the week...

  • Senior Civil Engineer

    2 weeks ago

    King of Prussia, United States BL Companies Full time

    Senior Civil Engineer - Land DevelopmentBL Companies is 100% employee owned, giving us a competitive edge and a unique distinction from most other companies. We offer a competitive benefit package which includes 6 paid holidays plus the week from Christmas to New Years paid, generous PTO, Medical, Dental and Vision insurance, disability insurance, life...

  • Senior Front End Developer

    2 days ago

    King of Prussia, United States TWO95 International Full time

    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 maintenance and enhancement of business-critical web-based applications in...

  • Senior Front End Developer

    2 weeks ago

    King of Prussia, United States TWO95 International Full time

    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 maintenance and enhancement of business-critical web-based applications in production.. ...

  • Senior Salesforce Commerce Cloud Developer

    1 month ago

    King of Prussia, United States Lilly Pulitzer Full time

    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 Disarming. Lilly Pulitzer is part of the Oxford Industries family of brands. Oxford...

  • Senior SQL Developer/ Lead

    5 days ago

    King of Prussia, United States NTT DATA Full time

    Reference #: 275714 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 - Onsite Hybrid to join our team in Oaks, PA. Job Responsibilities Include:...

  • Developer III

    2 weeks ago

    King of Prussia, United States JobRialto Full time

    Description: We are seeking a highly skilled Senior Cloud Platform Engineer or Sr Software Engineer with Cloud experience to join our team. The ideal candidate will have a strong background in cloud technologies, infrastructure design, and deployment strategies. This role will help maintain our cloud infrastructure to ensure scalability, reliability, and...

  • Senior Business Development Manager

    2 weeks ago

    King of Prussia, United States PVR Technologies Inc Full time

    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, identifying new business opportunities, and driving revenue growth. Key...

  • Senior Business Development Manager

    2 weeks ago

    King of Prussia, United States PVR Technologies Inc Full time

    Business Development ManagerKing of Prussia - PAJob 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, identifying new business opportunities, and driving revenue growth.Key...

  • Senior Business Development Manager

    2 weeks ago

    King of Prussia, United States PVR Technologies Inc Full time

    Business Development ManagerKing of Prussia - PAJob 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, identifying new business opportunities, and driving revenue growth.Key...

  • Senior Business Development Manager

    2 weeks ago

    King of Prussia, United States PVR Technologies Inc Full time

    Business Development ManagerKing of Prussia - PAJob 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, identifying new business opportunities, and driving revenue growth.Key...

  • Senior Manager

    1 day ago

    King of Prussia, United States Wesco Full time

    WESCO Senior Manager - Sales King of Prussia , Pennsylvania Apply Now As a Senior Manager – Sales, you will provide strategic direction and progressive leadership to achieve sales and profit goals within multiple locations or a largescale location with sales revenue above $50M or significant complexities. You will design and recommend sales and marketing...

  • Senior Mechanical Engineer

    3 days ago

    King of Prussia, United States New Life Staffing Full time

    Job Description Job Description Salary: 90-110K Travel Required: Typically, 2-3 times a month doing a client visit no more than 3 hours AutoCad experience is a must Design experience Field role client facing PE required 10+ years of experience Senior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and fire...

  • Senior Financial Analyst

    3 days ago

    King of Prussia, United States TerrAscend Full time

    At TerrAscend , we are on a mission to shape the future of the cannabis industry by creating leading marijuana-based therapies for patients and developing premium products for legalized adult recreational use. We are one of the largest and fastest growing multi-state, vertically integrated cannabis operators in North America. We’re on a roll and are just...

  • Senior Mechanical Engineer

    1 month ago

    King of Prussia, United States New Life Staffing, LLC Full time

    Job DescriptionJob DescriptionSalary: 90-110KTravel Required: Typically, 2-3 times a month doing a client visit no more than 3 hours AutoCad experience is a mustDesign experience Field role client facingPE required 10+ years of experience Senior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and fire...