Enterprise Data Warehouse Developer-BI Platform Engineer - Service Coordination, Inc.

Position Title: Enterprise Data Warehouse Developer BI Platform Engineer

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-BI Platform Engineer is responsible for establishing the standardized enterprise Business Intelligence Platform system architecture and for developing the structures needed to support the Director of Insights and the Centers of Excellence in delivering enterprise metrics and KPIs. This position is responsible for creating data mart structures, transforming and maintaining enterprise data within the data marts and data warehouse in order to support the enterprise analytics reporting needs. Responsibilities will include building a solid knowledge of the end-to-end enterprise data lifecycle, data mappings, data models, structures and dimensions within and between transaction systems to support the business intelligence reporting. The position will be responsible for developing ETL processes and assist in transaction system data administration. The position will 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 establishing the standardized Business Intelligence Platform system architecture and for developing the Business Intelligence Platform data structures needed to support the Director of Insights and the Centers of Excellence in delivering enterprise metrics and KPIs.
• Create data mart structures, transform and maintain enterprise data within the data marts to support the enterprise analytics reporting needs.
• Design, develop, document, and implement data mappings for data mart ETL implementations, data modeling implementations, and coding for data extraction from the enterprise source systems.
• Responsible for Data Integrity and Configuration Control within Transaction Processing, Data Transformations, Aggregates and Representations.
• Data Governance oversight responsibility within cross-functional programs.
• Enterprise Data Governance with design and audit, automated quality detections and controls within the Business Intelligence Architecture.
• 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 for consistent reporting.
• Focus to proactively improve and tuning data quality, accessibility, performance, and security needs.
• Supports EPM departmental goal of excellent service delivery by standardization, simplification and optimization of processes and operations.
• Actively participates in and/or lead technology committees, work groups, or project teams as assigned.

Supervisory Duties:

• This position does not have supervisory duties.

Education Required:

• Bachelor's degree in information or computer science or related fields or equivalent years of experience.

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, 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

Disclaimer: The recruitment process is approved by Service Coordination Inc.’s Recruitment Committee and subject to change based on business needs.

In recognition of the continuing COVID-19 pandemic, Service Coordination Inc (SCI) is committed to maintaining a safe and healthy workplace. Because of this, SCI is requiring all new hires to be fully vaccinated. New hires will be required to provide proof of vaccination status as part of the on-boarding process. SCI provides reasonable accommodations, absent undue hardship, for medical reasons under ADA and for employees with sincerely held religious beliefs, observances, or practices that conflict with getting vaccinated. You may request reasonable accommodation or other exemption to Sonji Ashford at sashford@sc-inc.org.

Service Coordination is an equal opportunity employer and committed to the full inclusion of all qualified individuals. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, hair texture or protected hairstyle, veteran status, or genetic information. Service Coordination is also committed to providing equal opportunity and access to individuals with disabilities by ensuring reasonable accommodations are provided to participants in the job application or interview process. To request a reasonable accommodation, contact Kathryn Eckert at kathryn.eckert@sc-inc.org or 410-218-5581.

SCI does not sponsor for immigration, including for H-1B, TN, and other non-immigrant visas, for this role.