Sr. Data Engineer Analytics

Planned Parenthood of Orange and San Bernardino Counties has a full-time opportunity for a Sr. Data Engineer Analytics in Anaheim, CA.

The successful candidate must possess the knowledge, skills, and abilities required to perform the essential duties of a Data Engineer & Analytics. The following requirements outline the necessary qualifications for this position. Reasonable accommodations may be provided to enable individuals with disabilities to fulfill their essential functions.

At PPOSBC, we understand the importance of a well-rounded benefits program and are dedicated to providing you with unique benefits that meet the needs of you and your family. We are proud to offer a range of plans that help protect you in the case of illness or injury including:

• A competitive benefits package including medical, dental, and vision coverage for you and eligible dependents, life insurance, and long term disability. 
• Benefits coverage starts after one full month of employment
• Generous vacation, sick, and holiday benefits
• Generous 401(k) matching contributions and more
• To view our detailed benefits guide, please visit our career site at www.pposbccareers.org

Essential Functions: The essential functions encompass the core tasks, duties, and responsibilities that are integral to the Data Engineer & Analytics role and contribute to the overall purpose of the job.

• Perform advanced data engineering and analytics to support key performance metrics.
• Resolve complex data engineering and analytics problems by conducting an in-depth analysis of various factors.
• Collaborate with stakeholders and department leaders to gather and clarify data requirements for sophisticated data engineering solutions and advanced analytics.
• Develop and optimize data pipelines, ETL processes, and workflows using tools such as SSIS, Azure Data Factory, Databricks, Talend, Informatica, StreamSets, or equivalent.
• Design and implement data models, database structures, and schema for efficient data storage, retrieval, and advanced analytics.
• Create and maintain reports, dashboards, and visualizations using tools like Microsoft Power BI, Tableau, Looker, QlikView, SSRS, or equivalent.
• Collaborate with cloud platforms like AWS and Azure to architect and implement scalable and robust data solutions for advanced analytics.
• Utilize advanced database performance tuning techniques to optimize data processing, query performance, and advanced analytics algorithms.
• Conduct in-depth data analysis and mining to identify patterns, correlations, and anomalies for further investigation and advanced analytics insights.
• Contribute to industry benchmarking analysis and develop quantitative business cases based on data insights and advanced analytics.
• Prepare and deliver presentations and recommendations to managers and senior leaders, providing expert consultation on data engineering, analytics, and advanced analytics techniques.
• Generate forecasts, recommendations, and strategic/tactical plans based on data analysis, advanced analytics, and market knowledge.
• Identify and resolve data-related errors and issues for end users, implement functional solutions, and provide necessary training and support for advanced analytics

Non-Essential Functions:
• Other duties as assigned

PHYSICAL REQUIREMENTS:
The physical requirements of this position are identified below. Reasonable accommodations may be made for individuals with disabilities to perform the essential functions of this position.

CORE COMPETENCIES – WE CARE:

• Welcoming: Anticipates customer requirements and gives high priority to customer satisfaction and service.  Handles problems quickly and efficiently.  Maintains a pleasant, positive and professional approach. Embraces opportunities to help team members, stakeholders, and other departments.
• Equitable: Creating equitable access and opportunity for all through education, practicing inclusive behavior, elevating others’ voices, creating spaces for honest conversation, and listening without judgment.  Values and uplifts our collective diversity within in our agency.
• Confidential: Respects the information shared by our patients, employees, and vendors and maintains appropriate confidentiality.  Follows all policies and laws that protect private & privileged information.
• Accessible: Is available and approachable to others, open-minded, fair and non-defensive.  Appreciates constructive feedback and is a team player.  Demonstrates good listening skills.
• Respectful:  Values diversity and treats everyone with dignity and courtesy.  Dependable and courteous of other people’s time and commitments.
• Empathetic: Demonstrates interest and understanding in other people’s feelings, attitudes and reasoning.  Maintains an open and non-judgmental demeanor that is patient, flexible, and understanding.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Minimum Education:
• A Bachelor's Degree in Computers, Statistics, Business, or other related area; and/or equivalent experience/training.

Minimum Work Experience:
• Minimum of five (5+) years of relevant experience, with a strong focus on data engineering and analytics.

Other Requirements:
• Hands-on experience with the complete data engineering stack, including:
Databases: Proficiency in working with databases such as Microsoft SQL Server, Azure SQL DB, Azure Synapse, Azure Analysis Service (AAS), Azure SQL Data Warehouse, AWS Redshift, Snowflake, or equivalent.
ETL: Extensive experience with ETL tools like SSIS, Azure Data Factory, Databricks, Talend, Informatica, StreamSets, or equivalent.
Data Visualization: Proficiency in creating reports, dashboards, and visualizations using tools such as Microsoft Power BI, Tableau, Looker, QlikView, SSRS, or equivalent.
Cloud Platforms: Familiarity with cloud platforms such as AWS and Azure.
• Strong expertise in database performance tuning to optimize data processing and query performance.
• Excellent communication skills, both written and verbal.
• Strong analytical and problem-solving abilities to address complex data engineering and analytics challenges.
• Advanced skills in Excel, including pivot tables and data modeling.
• Proficient in application environments, database connections, business logic, and SQL queries.
• Exceptional critical thinking skills with the ability to work in a fast-paced environment and manage multiple priorities effectively.
• Thorough understanding of business intelligence functions, analytics, industry standards, and best practices.
• Proven experience as a data engineering and analytics professional, capable of translating theoretical concepts into practical solutions. Possesses comprehensive knowledge of the field, can independently execute responsibilities, and demonstrates proficiency in analyzing problems and identifying suitable solutions.

Agency Standard Requirements:
• Strong commitment to quality healthcare and excellent customer service is required.
• Must thrive in a fast-paced, rigorous environment with changing priorities.
• Ability to meet deadlines and work under pressure
• Must demonstrate high-level computer skills including; Microsoft Word, Excel and Outlook. Electronic medical records experience may also be required.
• This position requires travel to other sites and locations; if using a personal vehicle to meet this requirement, a valid CA driver’s license and current auto insurance in compliance with the minimum requirements of CA vehicle code are required.
• Abortion patients are cared for at each of our health centers and in part through the administrative, support, and other non-clinical services provided at all PPOSBC locations and by all PPOSBC employees, and supporting these critical services is an essential job duty and fundamental responsibility of all employees.