Business Intelligence Developer II

Are you looking for a purpose-driven career? At Metrocare, we serve our neighbors with developmental or mental health challenges by helping them find lives that are meaningful and satisfying.

Metrocare is the largest provider of mental health services in North Texas, serving over 55,000 adults and children annually. For over 50 years, Metrocare has provided a broad array of services to people with mental health challenges and developmental disabilities. In addition to behavioral health care, Metrocare provides primary care centers for adults and children, services for veterans and their families, accessible pharmacies, housing, and supportive social services. Alongside clinical care, researchers and teachers from Metrocare’s Altshuler Center for Education & Research are advancing mental health beyond Dallas County while providing critical workforce to the state.

Job Description

GENERAL DESCRIPTION:

The mission of Metrocare Services is to serve our neighbors with developmental or mental health challenges by helping them find lives that are meaningful and satisfying. We are an agency committed to quality gender-responsive, trauma-informed care to individuals experiencing serious mental illness, development disabilities, and co-occurring disorders. Metrocare programs focus on the issues that matter most in the lives of the children, families and adults we serve.

Key Responsibilities

• Develop and optimize SQL queries, stored procedures, and functions to support application development and reporting needs.
• Build processes that support data transformation, data structures, metadata, dependency and workload management.
• Collaborate with cross-functional teams to understand and meet business needs.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Develop and maintain BI solutions using T-SQL, SSRS, SSIS, and Power BI.
• Experience working with large data repositories and relational databases.
• Experience with Power BI
• Ability to translate business needs, processes, and requirements into optimized data solutions.
• Ability to monitor performance of existing data jobs and address issues to ensure scalability.
• Understanding of business objectives and metrics, allowing for the alignment of analytical findings with organizational goals.
• Ensure data security and compliance with industry standards and best practices.
• Assist in database migration and upgrades while maintaining data integrity.
• Create and maintain documentation for data warehouse processes, data models, and architecture.
• Participate in code reviews and provide feedback to ensure code quality and adherence to standards.
  
  

Qualifications

• Bachelor’s degree in computer science, Information Technology, or equivalent quantitative field experience required.
• 5 years of experience in SQL Server or BI development.
• Strong skills in T-SQL, database design, and performance optimization.
• Proficiency with SSMS, SSIS, SSRS, and Power BI.
• Familiarity with data modeling techniques and database normalization.
• Experience with cloud platforms like AWS or Azure is a plus.
• Strong analytical and problem-solving skills.
• Database certifications are a plus.
  
  

What We Offer

• Competitive salary and comprehensive benefits package.
• Opportunities for professional development and career advancement.
• A collaborative and innovative work environment.
• Flexible work hours and remote work options.
  
  

This position requires initiative, independence, drive, and the ability to work successfully in a fast-paced, dynamic environment with the ability to perform a wide variety of responsibilities. Strong communication skills are an asset that will be helpful while working closely with various teams across the institute.

Essential Duties And Responsibilities

The essential functions listed here are representative of those that must be met to successfully perform the job.

• Expertise in developing complex and well-structured scripts and queries in SQL, TSQL, SSRS, SSIS.
• Experience working with large data repositories and/or relational databases.
• Experience as an ETL developer with strong data architecture knowledge around data warehousing concepts, SQL development and optimization, and operational support models.
• Knowledge of SAS tools.
• Experience with Power BI a plus
• Ability to develop file and database structures, and interfaces between internal and external systems
• Ability to build processes that support data transformation, data structures, metadata, dependency, and workload management.
• Experience building and optimizing big data pipelines, architectures, and data sets.
• Ability to translate business needs, processes, and requirements into optimized data solutions.
• Ability to monitor performance of existing data jobs and address issues to ensure scalability.
• Ability to monitor routine data loads and ensure they are successful.
• Ability to design solutions to be optimal for reporting, analytics, and dashboards.
• Ability to manage the technical documentation for all code, data definitions, dashboards, and data management applications.
• Ability to assist in ongoing development of technical best practices for data integration, data quality, data cleansing and other ETL related activities.
• Highly self-motivated and directed with keen attention to detail.
• Ability to work collaboratively in dynamic team environment.
• Performs other duties as assigned.
  
  

Competencies

The competencies listed here are representative of those that must be met to successfully perform the essential functions of this job.

• Conducts job responsibilities in accordance with the ethical standards of conduct, state contract, appropriate professional standards, and applicable state/federal laws
• Analytical skills, professional acumen, business ethics, thorough understanding of continuous improvement processes, problem solving, respect for confidentiality, and excellent communication skills.
• Effective verbal and written communication skills.
• Excellent organizational skills with the ability to prioritize workflow and meet deadlines.
• Ability to handle multiple task and special projects simultaneously.
• Able to work autonomously with minimal or no supervision.
• Able to maintain a high level of professionalism and confidentiality.
  
  

Qualifications

EDUCATION AND EXPERIENCE:

• Bachelor's degree in Computer Science, Information Systems or equivalent quantitative field experience required. 7 years of experience in a reporting, data and analytics role.
• Experience working with and extracting values from large, disconnected and or unstructured datasets.
  
  

Mathematical Skills

• Basic math skills required.
• Ability to work with reports and numbers.
  
  

Reasoning Ability

Ability to apply common sense understanding to carry out simple one or two-step instructions. Ability to deal with standardized situations with only occasional or no variables.

Computer Skills

• Use computer, printer, and software programs necessary to the position (i.e., Word, Excel, Outlook, and PowerPoint).
• Ability to utilize Internet for resources.
  
  

Certifications, Licenses, Registrations

• Current State of Texas Driver License or if you live in another state, must be currently licensed in that state. If licensed in another state, must obtain Texas Driver License within three (3) months of employment.
• Any Database Certification a plus.
• Any BI Certification a plus.
  
  

PHYSICAL DEMANDS & WORK ENVIRONMENT

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations can be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the incumbent is regularly required to talk and hear, use hands and fingers to operate a computer and telephone. Due to the multi-site responsibilities of this position the incumbent must be able to carry equipment and supplies (up to 15 pounds). The position requires standing and/or walking in excess of 7 hours a day.

Travel

In county travel may be required: For Trainings.

NOTICE ON POSITIONS THAT REQUIRE TRAVEL TO/FROM VARIOUS WORKSITES

Positions that are community-based, in whole or part, require the incumbent to travel between various worksites within his/her workday/workweek. The incumbent is required to have reliable transportation that can facilitate this requirement. The incumbent is further required to meet the criteria for insurability by the Centers risk management facilitator; and produce proof of minimal auto liability coverage when applicable. Failure to meet these terms may result in disciplinary action up to and including termination of employment, contract or other status with Metrocare.

Work Environment

The work environment describe here is representative of that which an employee encounters while performing the essential functions of this job. Reasonable accommodation can be made to enable individuals with disabilities to perform the essential functions.

The noise level may vary between low and mild.

The work environment should not be unusually hot or cold.

80-90% Remote

This job description is a record of major aspects of the job but is not an all-inclusive job contract. Dallas Metrocare Services maintains its status as an at-will employer and nothing in this job description shall be interpreted to guarantee employment for any length of time. Additional tasks may be assigned as deemed necessary by the immediate supervisor. The positions status conforms to the Fair Labor Standards Act of 1939 as amended, and the employee has agreed to the standards methods of compensation in compliance with Centers procedures and Federal Law.

Benefits Information And Perks

Metrocare couldn’t have a great employee-first culture without great benefits. That’s why we offer a competitive salary, exceptional training, and an outstanding benefits package:

• Medical/Dental/Vision
• Paid Time Off
• Paid Holidays
• Employee Assistance Program
• Retirement Plan, including employer matching
• Health Savings Account, including employer matching
• Professional Development allowance up to $2000 per year
• Bilingual Stipend – 6% of the base salary
• Many other benefits
  
  

Equal Employment Opportunity/Affirmative Action Employer

Tobacco-Free Facilities - Metrocare is committed to promoting the health, well-being, and safety of Metrocare team members, guests, and individuals and families we serve while on the facility campuses. Therefore, Metrocare facilities and grounds are tobacco-free.

No Recruitment Agencies Please