Business Intelligence Developer II

Metrocare Services•Dallas, TX

33d•Remote

About The Position

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

Requirements

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.
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.
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.
Use computer, printer, and software programs necessary to the position (i.e., Word, Excel, Outlook, and PowerPoint).
Ability to utilize Internet for resources.
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.

Nice To Haves

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.
Knowledge of SAS tools.
Experience with Power BI a plus

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.
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 as an ETL developer with strong data architecture knowledge around data warehousing concepts, SQL development and optimization, and operational support models.
Ability to develop file and database structures, and interfaces between internal and external systems
Experience building and optimizing big data pipelines, architectures, and data sets.
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.
Conducts job responsibilities in accordance with the ethical standards of conduct, state contract, appropriate professional standards, and applicable state/federal laws