Address
Form of work
SalaryPosition 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.
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:
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 end-to-end 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 (hub-spoke), Data Marts, Business Intelligence, Quality Detections.
- Development of API interfaces, point-to-point 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 end-to-end 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:
Minimum 7-10 years professional experience with Enterprise Data management, data warehousing, application interfaces and communicating business data needs and end-to-end workflows.
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): Quickly finds common ground to solve problems. Is seen as a cooperative team player. Provides coaching and mentoring to team members. Consistent communicator, provides team members with the tools they need to perform their jobs in a timely manner. Explores all available options to make the best decision for internal and external holders
Diversity: Values, appreciates and honors the ways in which cultural differences can create value in organizations. Is service oriented: Demonstrates a commitment to the philosophies for services and the goal of independence for the people we serve. Raises awareness in communities to appreciate the similarities and unique gifts of each person. Interacts with all kinds of team members equitably, deals effectively with all races, nationalities, cultures, disabilities, ages, and genders, supports equal and fair treatment and opportunity for all.
Driving Solutions (Perseverance): Pursues all initiatives with energy, drive, and the goal to succeed.
Job-Specific Competencies:
Functional/Technical Skills: Has the functional and technical knowledge and skill to perform their role at a high level of accomplishment.
Integrity and Trust: Follows through with assigned tasks, goals and responsibilities, maintains confidentiality, utilizes company resources effectively, and reliably follows through on commitments made to others.
Organizational Agility: Understands the origin and reasoning behind key policies, practices and procedures, understands the culture of the organization.
Technical Learning: Easily learns new skills. Proficient at understanding other industries, companies, products, or information.
Conflict Management: Reads situations quickly and without bias, can find common ground and inspire cooperation, solution-oriented.
Physical Demands: Generally, presents standard office environment. Must be able to remain in a stationary position >95% of the time. Continually operates a computer, keyboard and mouse, and other office productivity machinery, such as a calculator, copy machine, printer, and mobile Smartphone device. Constantly positions self to comfortably maintain computer equipment. May occasionally be required to move about in an office setting or position office equipment weighing between 10-25 pounds. Vision abilities required by this job include close vision. Ability to operate a motor vehicle. The person in this position frequently communicates with other people. Must be able to exchange accurate information in these situations.
IT Roles must be able to position self to maintain computers and equipment, including under desks and in server room(s). Frequently moves equipment weighing up to 50 pounds.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job. This job description is subject to change at any time.
- SCI does not sponsor for immigration, including for H1B, TN, and other non-immigrant visas, for this role.
#INDSCIO
