About Private Client Select Insurance Services, LLC (PCS)
PCS is one of the largest high net worth managing general underwriters in the market today. With a sole focus on families with $5m or more in assets, PCS provides complex insurance policies for individuals with complex needs. Private Client Select offers property and casualty personal insurance solutions and risk management services that meet the unique and complex needs of High-Net-Worth clients. We understand their passions and are committed to preserving the life that they have built.
PCS employs approximately four hundred staff members. The company is based in Berkley Heights, NJ with additional offices in New York, NY, and Schaumberg, IL. The ideal candidate will be in the metro New York area, Chicago, or near St. Petersburg, Florida, to allow for regular in-office presence. This role is considered hybrid, offering flexibility in work arrangements but the expectation will be that an office visit will be required multiple times a week.
Position Summary
As a member of our Private Client Select data team you will focus on data design and ETL programming supporting personal lines Property & Casualty products for high net-worth individuals in the US.
Responsibilities
- Lead the design, development, and implementation of ETL processes using tools like Azure Data Factory and IBM DataStage.
- Design and implement scalable and secure data architectures using Azure services. This includes designing data models, schemas, and data flows that align with business requirements.
- Integrate data from diverse sources, including databases, APIs, and file systems, into Azure data platforms or Oracle RDS.
- Develop complex SQL queries and ensure optimized database performance.
- Design and optimize data structures and schemas to support business requirements.
- Apply data modeling techniques to create robust and scalable data models.
- Utilize programming languages such as Python, Java, or Scala to script and automate ETL processes.
- Develop and maintain custom ETL solutions to meet specific business needs.
- Analyze and troubleshoot data integration issues, ensuring ETL processes run smoothly.
- Identify, diagnose, and resolve complex data transformation challenges.
- Plan and manage ETL project tasks, resources, and timelines to meet delivery commitments.
- Employ Agile or other project management methodologies to enhance project efficiency.
- Collaborate with stakeholders to gather requirements and provide regular updates on project progress.
- Document ETL processes and create clear technical documentation for team and stakeholder reference.
- Conduct thorough testing and validation of ETL processes to ensure data accuracy and consistency.
- Implement quality assurance practices to maintain high data integrity.
- Mentor and lead a team of ETL developers and data engineers, fostering a collaborative work environment.
- Coordinate with cross-functional teams to ensure alignment and effective execution of data integration projects.
- Interpret business requirements and translate them into technical ETL specifications.
- Ensure ETL solutions align with the organization's strategic goals and objectives.
- Stay current with emerging technologies and tools in the data integration landscape.
- Adapt to changing project requirements and priorities, demonstrating flexibility and innovation.
Qualifications
- In-depth knowledge of ETL tools such as Informatica or DataStage. Experience with DataStage/QualityStage programming (6+ years preferred).
- Proficiency in Azure services like Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Azure SQL Database, and Azure Data Lake Storage.
- Strong skills in SQL for database querying, manipulation, and optimization.
- Experience with SQLServer, Snowflake, and Databricks is preferred.
- Knowledge of data modeling, data warehousing concepts, and dimensional modeling.
- Familiarity with Oracle/Exadata/RDS Data Warehouse experience (10+ years preferred).
- Experience with programming and scripting languages such as Python.
- Experience with DuckCreek and/or Instanda data mapping. Insurance Bordereau process experience and strong knowledge of underwriting concepts, practices, and procedures.
- Personal Lines Property & Casualty Insurance domain knowledge (5+ years preferred).
- Strong analytical and problem-solving skills for troubleshooting data issues and optimizing solutions.
- Competence in managing projects, including planning, scheduling, and tracking progress. Ability to prioritize work and meet deadlines while working in a dynamic, rapidly changing environment.
- Excellent verbal and written communication skills for clear interaction with stakeholders and team members.
- Strong interpersonal skills and the ability to collaborate with a wide range of colleagues.
- Detail-oriented with the ability to self-direct and take initiative on projects and assignments.
- Proven experience in leading and mentoring teams, fostering a collaborative environment.
- Ability to stay updated with the latest ETL tools and methodologies while adapting to new challenges and technologies.
- Bachelor's degree in a related field is preferred.
Equal Employment Opportunity Policy
PCS values and is fully committed to diversity and inclusion. It is the policy of PCS not to discriminate against any applicant for employment, or any employee because of age, color, sex, disability, nation of origin, race, religion, sexual orientation, gender identity, or veteran status.