Senior Analytics Engineer
Martins Point Health Care
As a member of the Data Architecture Team, the Senior Analytics Engineer will recommend architecture solutions and is responsible for the architecture, design, development, and maintenance of the data warehouse; data marts, staging and archival databases through the life cycle: from business requirements to development of logical design, translation to physical design, ETL architecture and code development, and on through implementation and maintenance. This would also include documenting processes, documenting data structures, and creating Entity Relationship Diagrams (ERDs) all in support of the organizations internal and external data needs.
Martin’s Point maintains a data warehouse containing data from all aspects of its’ operations. The Data Architecture Team supplies analysis and reports to all departments at Martin’s Point from the executive level to the management team as well as frontline staff, all with the goal of improving performance throughout the organization.
Key Outcomes:
- Architects, designs, and develops enterprise data warehouse, data mart, operational and other miscellaneous components using stored procedures, functions, views, and other ETL Tools for use by business intelligence (BI) applications
- Assists the Reporting Team in the design of database structures to support reporting and analysis
- Works with business owners and business users to understand and translate user requirements into practical data models
- Reviews database architectures and designs to ensure data integrity and quality, performance, management, scalability, etc.
- Designs, develops, and implements conceptual data models for BI solutions
- Validates ETL processes by developing and executing test plans and scenarios to ensure viability of code prior to implementation in production
- Designs, develops, and deploys back-end systems to support operational and analytical reporting
- Creates and maintains documentation of processes, reports, applications, and procedures for consistency, process improvements and team development
- Maintains the data warehouse metadata repository to ensure compliance with industry standards
- Supports the data warehouse loads and other processes in conjunction with other members of the architecture team to ensure business data continuity
- Optimizes programmed code for best possible speed and performance
- Maintains all data warehouse and other processes and responds to critical data warehouse issues during off hours
- Makes and maintains recommendations for architecture solutions that support business and technical requirements and provide for scalability and availability of data and resources
Education/Experience:
- Bachelor’s degree in computer science, information technology, management systems or related discipline or equivalent work-related experience
- 6+ years of experience in data warehousing, including extensive experience working with ETL processes, OLAP structures, SQL coding and dimensional modeling writing T-SQL code and procedures
- Experience with Talend or other Integration tools such as SSIS
- Experience with metadata management and change management/version control concepts
- Formal data modeling experience
- Experience in the health care industry, from payer or provider perspective, preferred
In compliance with our contract with the Dept of Defense, any/all applicants must be a US citizen to meet application requirements.
Full Time
Salary range:
$100,000 – $150,000