Enterprise Data Warehouse Developer - Washington, United States - Service Coordination, Inc.

Service Coordination, Inc.

Verified Company

Washington, United States

1 week ago

Posted by:

Mark Lane

beBee recruiter

Description

Position Title:

Enterprise Data Warehouse Developer Employment Status:
Full-time Reports to: Enterprise Application Systems Manager FLSA Status: Exempt

SCI Summary:

SCI supports people with disabilities, behavioral challenges, medically complex needs, transitioning youth, the elderly, and other populations using Maryland Department of Health's Targeted Case Management and Supports Planning work models as well as a concierge level geriatric care management and care partner model.

Why should YOU want to work with us?

We offer competitive pay, including ALL travel (mileage + drive time) and up to an 8% performance bonus.
Generous Employee Referral Program
Excellent benefits, including a tuition reimbursement program, a student loan repayment program, medical, dental and vision plans, 100% employer paid shortterm and longterm disability and life insurance, 403(b) match (up to 5% of your annual salary), generous vacation and sick leave accrual and holiday pay
Extensive paid training and employerprovided laptop and cell phone
Supportive Leadership Teams that want you to succeed, participate in your training and facilitate open communication through monthly Town Halls and Annual Reviews

Position Summary:
The Enterprise Data Warehouse Developer is responsible for creating, designing, developing and maintaining sourcing new Enterprise Data Warehouse.

Responsibilities include building knowledge of end-to-end enterprise data lifecycle, data mapping, data models, structures and dimensions within and between transaction systems through to business intelligence reporting.

Also includes development of APIs, ETL processes and transaction system data administration. At all times, ensures data integrity, quality of all project deliverables and promotes cross functional, collaborative partnership and decision-making.

SCI Team Member Expectations:

All SCI team members are expected to: Ensure services provided follow the organization's mission statement, core operating values and policies and procedures.

follow HIPAA, confidentiality and security procedures and principles; collaborate with peers, leadership, and support areas of the organization; actively participate in and contribute to leadership and other staff meetings and trainings; maintains compliance with federal, state, and local employment laws and regulations; follow self-direction and person-centered planning procedures and philosophy; and to foster a culture that values diversity.

Essential Duties:

Responsible for designing, developing, transforming and maintaining enterprise data within transactional systems, data repositories, interfacing systems and within centralized Enterprise Data Warehouse(EDW) and through to Business Intelligence (BI) platform.
Design, develop and document data models, data mapping and business rules to ensure endtoend rigor from source systems through ETL implementations into EDW and BI.
Code, test, monitor and maintain data integrations with transaction systems, data sources.
Responsible for Data Integrity and Configuration Control within Transaction Processing, Data Transformations, Aggregates and Representations. '
Implement data interfaces and automation for sourcing referential data to other transaction systems (hubspoke), Data Marts, Business Intelligence, Quality Detections.
Development of API interfaces, pointtopoint integration, custom automation scripts and continuous verifications from transaction systems and data sources.
Data Governance oversight responsibility design for audit, automated quality detections and controls.
Roadmap Release planning of Strategic Outcomes, Leading Indicators, KPIs, Industry impact metrics
Develops SCI Expertise/Applies Relevant Industry Expertise to advance business goals. Optimized endtoend data flows and data models consistently.
Focus to proactively improve and tuning data quality, accessibility, performance, and security needs.
Supports Enterprise Project Management departmental goal of excellent service delivery by standardization, simplification, collaboration and optimization of processes and operations.
Actively participates in and/or lead technology committees, work groups, or project teams as assigned

Education Required:
Bachelor's degree in information or computer science or related fields

Experience Required:

SCI Value Related Competencies:
People Come First (Customer Focus): Thinks and acts with people we support in mind when making decisions. Dedicated to meeting the expectations and requirements of internal and external shareholders, uses information and feedback to improve services.

Building Relationships and Connections:
Interpersonal savvy. Relates to all kinds of people. Builds appropriate rapport, uses diplomacy and tact, diffuses high-tension situations comfortably. Establishes and maintains meaningful connections within the community and the organization (internal and external stakeholders)

Education (Informing Others): Quic