Database Architect

Folsom, CA, United States

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

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

Analytics development, report development, relational database, and SQL language.

Should be well versed with data structures algorithms.

Understanding of Software 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

CLICK HERE FOR DETAILS

#J-18808-Ljbffr