Enterprise Data Warehouse Developer

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 short-term and long-term 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 employer-provided 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:

1. 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.
2. 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.
3. Code, test, monitor and maintain data integrations with transaction systems, data sources.
4. Responsible for Data Integrity and Configuration Control within Transaction Processing, Data Transformations, Aggregates and Representations. '
5. Implement data interfaces and automation for sourcing referential data to other transaction systems (hub-spoke), Data Marts, Business Intelligence, Quality Detections.
6. Development of API interfaces, point-to-point integration, custom automation scripts and continuous verifications from transaction systems and data sources.
7. Data Governance oversight responsibility design for audit, automated quality detections and controls.
8. Roadmap Release planning of Strategic Outcomes, Leading Indicators, KPIs, Industry impact metrics
9. Develops SCI Expertise/Applies Relevant Industry Expertise to advance business goals. Optimized end-to-end data flows and data models consistently.
10. Focus to proactively improve and tuning data quality, accessibility, performance, and security needs.
11. Supports Enterprise Project Management departmental goal of excellent service delivery by standardization, simplification, collaboration and optimization of processes and operations.
12. 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.

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 [email protected].

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 [email protected] or 410-218-5581.

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