Database Architect - Full-time

Job Title: Database Architect

Pay Scale: $100,000 to $175,000 annually

Location: Folsom, CA (Not eligible for remote work)

About Opeeka

Opeeka is an innovative technology company, committed to boosting the health and well-being of people from all walks of life. Opeeka is the nation’s leader in care collaboration and person-centered outcomes measurement. We provide a robust Software as a Service (SaaS) solution to Healthcare Providers, Healthcare Insurance Companies, Government Agencies, and Community Based Organizations that serve people in need. Opeeka’s success and impact has been recognized in the healthcare industry and we are poised to significant growth and continued impact. Learn more at www.opeeka.com/news

Person-Centered Intelligence Solution (P-CIS), Opeeka’s principal technology, is a patient outcomes platform that connects to care organizations’ existing technology to extend its capability to support value-based care. Payers, states, counties, and care providers use P-CIS to unify the continuum of care, reduce burden on staff, and improve patient outcomes. There is no other technology on the market like P-CIS. It is the only platform to symbiotically work within the ecosystem of care technology to improve workflow, outcomes, care coordination, and overall care system performance.

Opeeka is searching for individuals to join our team who are comfortable working in a fast paced environment and are interested in leveraging their proven skills to help Opeeka capitalize on the significant growth opportunities ahead. If you are someone who is looking for an exciting opportunity with an early stage technology leader, keep reading.

Company Benefits

Opeeka offers a full range of competitive Company benefits to eligible employees...

Vacation

Full-time employees are eligible to earn and accrue vacation upon the first day of work. All full-time employees are eligible to accrue at least 80 hours of paid vacation time annually, and annual vacation time increases based on tenure.

Sick Time

All employees will be granted 5 days (40 hours) of paid sick leave in a lump sum at the time of hire and subsequently, at the beginning of each year on January 1st. Employees may begin to use paid sick leave on their 90th day of employment (or sooner, if applicable law requires). Employees can use up to 5 days (40 hours) of paid sick leave per year.

Holiday Pay

Upon hire, all employees will receive holiday pay for the Company observed holidays, which includes all Federal Holidays and the day after Thanksgiving.

Medical Insurance Benefits

Opeeka provides the option of a comprehensive medical insurance plan for eligible full-time employees and their dependents. Employees are eligible to enroll in the medical program on the first of the month following 30 days of continuous employment. The Company will pay a portion of the medical insurance premium, up to $550 per employee and up to $450 for covered dependent(s). Medical insurance benefits are available to employees, the employee’s spouse or registered domestic partner, and the employee’s legal dependents.

Dental and Vision Benefits

Eligible full-time employees may also enroll in an employee only, an employee plus children or a family contract on the first of the month following 30 days of employment.

Retirement Plan

Opeeka provides all employees who complete 90 days of employment with a SIMPLE IRA plan which is an excellent means of long-term savings for your retirement. For eligible employees, the Company will contribute a dollar-for-dollar contribution match, up to 3% of the employee’s annual compensation.

Job Summary

Works with Opeeka development team and is responsible for developing and evolving SQL server databases to support data collection and data mining necessary for Opeeka’s P-CIS analytics and reporting. This position will collaborate with internal customers to capture requirements, design, create, document, manage and fulfill requests for on-going and/or ad-hoc reports, dashboards, analytics and scorecards. Will also work with external customers to define, design, and/or develop data pipelines and data stores and ETL processes for both operational and analytic purposes. Responsible for developing and architecting data strategies that will enable secure and performant use of the data platform for Power BI solutions (and other business intelligence platforms), advanced analytics and querying engine.

Will also include collaborating and reviewing current data with team members to analyze user needs and develop software solutions, applying principles and techniques of computer science, engineering, and mathematical analysis. Update software or enhance existing software capabilities. May work with cloud computing engineers to integrate cloud and software systems, and develop or modify specifications and performance requirements. May create of modify database designs, working individually or coordinating database development as part of a team. Provide knowledge in design, architecture, development and administration.

Duties & Responsibilities

• Design relational databases to support business enterprise applications and physical data modeling according to project requirements

• Review existing data architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing under-performing areas
• Model, design, and implement architectural strategies to meet stated requirements for metadata management, operational data stores and Extract Transform Load (ETL) environments
• Improve system performance by conducting tests, troubleshooting, optimizing SQL calls, and integrating new elements
• Create data dictionary definitions, governance practices, and standards
• End-to-end data lifecycle management activities, evaluating and recommending new and emerging data management and storage technologies
• Work with business units, functions, and leaders to prioritize business information needs.

• Responsible for developing and architecting data strategies that will enable secure and performant use of the data platform for BI solutions, advanced analytics and querying engine
• End to End responsibility for data collection, transformation, storage, governance, and consumption
• Manage and define processes of external and internal data integrations
• Work closely with software engineers and DevOps teams to ensure APIs, data models, connectors, microservices are efficient and performant
• Lead architecture, build self-service data access capabilities and smart APIs to drive data decisions
• Lead cost efficiency, cost optimization efforts to minimize data warehouse/virtual warehouse costs
• Improve data quality, data validation layers to help the BI solutions highlight rich data
• Collaborate with development teams and product owners to implement data strategies and plans that align with business objectives and performance goals
• Design and implement virtual warehouses for existing and new use cases
• Collaborate with team members in driving backend REST API development
• Work with project management to integrate new customers through ETL and custom development processes
• Work with product management to help drive design decisions and work with the development team for implementation
• Troubleshoot production issues and helping to resolve any critical bugs for customers
• Provide guidance to junior and mid-level developers on best practices

Financial Responsibilities:

Includes tracking and monitoring actual labor hours associated with projects to ensure labor costs stay within approved project budget.

Supervisory Responsibilities

There are no supervisory responsibilities for this position.

Qualifications

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.

Skills and Abilities

• Analyticsdevelopment,report development, relational database andSQLlanguage.
• Should be well versed withdata structures algorithms.
• Understanding ofSoftware Development Lifecycle .
• Extensive hands-on experience with DWH, APIs, Data Lake environments.
• Strong understanding of cloud infrastructure, services and protocols like EHRs, EMRs, Athena, Scala, Databricks, Snowflake, Spark, RDS, glue, Redshift, Apache airflow, SQS, SNS.
• Azure Data Factory,Azure DevOps, Azure Storage Data Lake, Extraction, Transformation and Loading.
• Hands-on experience in developing data enterprise solutions using Azure services.
• Excellent communication skills, with the ability to communicate technical concepts and solutions to both technical and non-technical stakeholders and management.
• Demonstrated ability to troubleshoot application issues.
• Excellent analytical and problem solving skills

Knowledge

• Demonstrated ability to create Azure Functions is a plus.
• Familiarity with Jira and BitBucket is a plus.

Education and/or Experience

• BS degree in CS, Computer Engineering, or related experience
• 8+ years experience defining, designing, and/or developing data pipelines and data stores for both operational and analytic purposes. This experience must include reviewing current data structures/schemas and recommending optimizations and reconfigurations as warranted.
• 6+ years with .NET Framework and .Net Core, specifically C#, MVC Experience
• 5+ years API/Web Service Development: REST/Web Services/API/SOAP/WCF
• 5+ years of using Microsoft SQL Server with strong SQL skills
• 4+ years doing integration work with ETL type tools
• 3+ years working with Microsoft Azure
• Experience with software development methodologies
• Related development experience: .Net Core, NodeJS, JSON is a plus
• Experience with PowerShell, Python, and other scripting languages is a plus

Physical Requirements:

• Frequent on-site, team interaction
• Frequent sitting, standing, and walking
• Occasional to frequent repetitive motion
• Frequent talking and listening in person and over the phone
• Close up and distance vision requirements

Emotional/Psychological Demands:

Ability to cope with: long periods of concentration; pressure and deadlines; occasional long or irregular hours; occasional public contact; changing priorities

Work Environment:

Open office environment; moderate temperatures; moderate noise levels