This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This role involves developing and maintaining ETL processes using Snowflake. - Develop and maintain ETL processes using Snowflake - Design and implement data models and schemas in Snowflake - Optimize and tune Snowflake queries for performance - Collaborate with data analysts and business stakeholders to understand data requirements - Ensure data quality and integrity across the Snowflake environment Qualifications - Bachelor’s degree in Computer Science, Data Science, or a related field - At least 9 years of experience working with Snowflake - Strong SQL skills and experience with data warehousing concepts - Experience with ETL tools and processes - Knowledge of cloud platforms (AWS, Azure, GCP) is a plus Requirements - Strictly no C2C / 1099 / third-party companies; all roles are W2 only - Coding test is required for every role - At least 3 to 5 years of real-time experience preferred Company Description Bright Vision Technologies is a forward-thinking software development company dedicated to building innovative solutions that help businesses automate and optimize their operations. We leverage cutting-edge technologies to create scalable, secure, and high-performance applications.

• Design and develop ETL pipelines using Oracle Integration Cloud (OIC), Informatica, Talend, or equivalent middleware tools to transform extracted legacy HR data into Oracle Fusion HCM HDL and HSDL load file formats • Build data transformation rules that map legacy data values (codes, descriptions, hierarchies) to Oracle Fusion HCM reference data, value sets, and lookup values for each agency migration • Develop data cleansing pipelines that identify and remediate data quality issues including missing required fields, invalid date formats, duplicate records, and referential integrity violations before target system loading • Design and implement batch processing frameworks capable of handling large-volume agency migrations ranging from small to very large agency employee populations with configurable parallelism and restart/recovery capabilities • Build comprehensive error handling and exception management within ETL pipelines including error categorization, automated retry logic, and error reporting dashboards for migration teams • Develop data reconciliation processes that compare source record counts, key data element values, and business rule validations between legacy extracts, transformation outputs, and target system loaded records • Create and maintain data quality dashboards providing real-time visibility into migration pipeline status, error rates, data completeness metrics, and reconciliation results for each agency migration wave • Design reusable transformation templates and parameterized mapping configurations that accelerate successive agency migrations by leveraging patterns from completed migrations • Collaborate with legacy system export developers (PeopleSoft/EBS team) to define extraction file formats, handoff procedures, and data interface specifications • Support iterative mock migration cycles (typically 3-4 per agency) and final cutover data loads, optimizing pipeline performance and resolving data quality issues identified in each cycle • Document ETL design specifications, transformation rules, data flow diagrams, and operational runbooks for each agency migration in accordance with SAFe Agile artifact standards • Apply established methods, standards, and practices to independently resolve functional and technical issues of moderate scope, contributing to team knowledge bases and consulting with senior staff on complex or unfamiliar problems as they arise • Communicate effectively with project team members and direct stakeholders to report progress, explain technical approaches, and support collaborative problem-solving within assigned workstreams and Agile Release Train ceremonies

• Architect Foundry Pipelines: Design, develop, and maintain scalable data pipelines within the Palantir Foundry ecosystem (Data Connection, Code Repos, Pipeline Builder). • Implement ETL processes: Implement ETL and real-time data pipelines for efficient data handling and integration. • Optimize PySpark: Write and tune high-performance Python/Spark code to transform massive insurance datasets into actionable insights. • Build the Ontology: Manage and scale the Foundry Ontology, ensuring data models accurately represent complex real-world insurance entities. • Implement AI/GenAI: Integrate GenAI capabilities (using Palantir AIP or external AI APIs) to automate workflows and enhance data enrichment. • Implement CI/CD: Implement practices using CodePipeline and CodeBuild to streamline development and deployment processes. • Collaboration & Agile Development: Gather requirements, set targets, define interface specifications, and conduct design sessions. Work closely with data consumers to ensure proper integration. Adapt and learn in a fast-paced project environment.

As a leading financial services and healthcare technology company based on revenue, SS&C is headquartered in Windsor, Connecticut, and has 27,000+ employees in 35 countries. Some 20,000 financial services and healthcare organizations, from the world's largest companies to small and mid-market firms, rely on SS&C for expertise, scale, and technology. Job Description Lead Data Engineer (SS&C Technologies, Inc.; San Francisco, CA): The Lead Data Engineer is based at SS&C’s office in San Francisco, CA with a telecommuting benefit. The incumbent must reside within commuting distance from SS&C’s San Francisco office. The Data Engineer will join a team that creates a leading cloud platform with the latest big data, cloud native and machine learning technologies. Specific responsibilities will include: Build and implement models in a production environment for a revenue-driving product; Create and maintain overall optimal data pipeline architecture; Assemble large, complex data sets that meet functional / non-functional business requirements; Manage data migrations/conversions and troubleshooting data processing issues; Create the pipeline for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources; Build large scale data platform infrastructures to power other products; Lead a squad (feature team) to deliver strategic client features including data movement and data synchronization; and Work with other architect engineers to propose architecture designs that will solve a business problem with bigger impact and reduce technical debts in the long run. Minimum requirements: Master’s degree or foreign equivalent in Computer Science, Data Analytics, Information Technology Management, or related field, plus 3 years of pre- or post-Master’s experience in any occupation in which the required experience is gained. Alternate Education and Experience: Bachelor’s degree or foreign equivalent in Computer Science, Data Analytics, Information Technology Management, or related field, plus 6 years of experience in any occupation in which the required experience is gained. Must have: Master programming skills in Python and SQL. Deep knowledge of big data platforms technologies including Spark, Hive, Airflow, Data Hub, Delta Lake or Iceberg. Strong algorithm & data structure basis. Experience leading a team technically to deliver large business features. Great architecture principles and decision-making skills. Strong problem-solving skills with a can-do attitude. Great software engineering best practices with git and version control systems. Solid communication skills to explain complex data pipelines to both technical and non-technical people. Excellent writing and documenting skills. Salary: $194,834.00 to $210,000.00 per year. Apply online at https://www.ssctech.com/about-us/careers or send resume to: Angela Lamar, Talent Acquisition, SS&C Technologies, Inc., alamar@sscinc.com. Ref: 00087619. An EOE. #LI-DNI Unless explicitly requested or approached by SS&C Technologies, Inc. or any of its affiliated companies, the company will not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services. SS&C offers excellent benefits including health, dental, 401k plan, tuition and professional development reimbursement plan.SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status or any other classification protected by applicable discrimination laws. Salary is determined by various factors including, but not limited to, relevant work experience, job related knowledge, skills, abilities, business needs, and geographic regions. California: Salary range for the position: 194,834 USD to 210,000 USD.