Metrocare Services · 1 month ago
Business Intelligence Developer II
Dallas, TX
Full-time
Onsite
Senior Level
7+ years expMetrocare Services is the largest provider of mental health services in North Texas, dedicated to serving individuals with developmental or mental health challenges. The Business Intelligence Developer II role focuses on developing and optimizing data solutions to support application development and reporting needs, while collaborating with cross-functional teams to meet business objectives.
Health CareHealth DiagnosticsHospitalMedicalMental Health
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
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
Qualification
Required
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
Strong analytical and problem-solving skills
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
Basic math skills required
Ability to work with reports and numbers
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
Ability to utilize Internet for resources
Preferred
Experience with cloud platforms like AWS or Azure is a plus
Database certifications are a plus
Any Database Certification a plus
Any BI Certification a plus
Experience with Power BI a plus
Knowledge of SAS tools
Benefits
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
Company
Metrocare Services
Metrocare is North Texas’ leader in mental health, developmental disability and substance abuse services.
1001-5000 employees
H1B Sponsorship
Metrocare Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (2)
Funding
Current Stage
Late StageTotal Funding
$2.5MKey Investors
Communities Foundation of Texas
2025-06-26Grant· $2.5M
Leadership Team
John Burruss, M.D.
Chief Executive Officer
Kelli Laos
Chief Operating Officer
Recent News
2025-07-12
2025-06-27
Company data provided by crunchbase