Position Summary
The Senior Data Analyst will provide technical data systems & analytics expertise to multiple service lines and geographic markets. This position will work with senior leadership and clinical staff to understand their needs and develop data solutions to improve operations. The Senior Data Analyst will maintain and support cloud (AWS) database infrastructure, help maintain PostgreSQL databases and ingest HL7/ADT data feeds using a Mirth Interface Engine.
The Senior Data Analyst will develop and maintain ETL processes and data pipelines using tools such as SSIS and Visual Studio. Additionally, the Senior Data Analyst will develop new dashboards using Power BI and will convert existing Tableau dashboards to Power BI. They will also analyze large sets of data to create meaningful insights that can help improve operations. The person in this role will also be responsible for validating, assessing, and improving data quality as well as maintaining relevant process documentation and data dictionaries, and acting as a Power BI administrator.
Position Requirements
Education:
- Bachelor's degree in computer science, information systems, information management, data science, applied mathematics, social sciences, or a related field required.
- Master's degree preferred.
Experience:
- 4 years of experience developing ETL processes, building data pipelines, and managing databases required.
- 4 years working in informatics, analytics, business intelligence, and/or strategic information required.
- 4 years of experience using SQL and other programming languages, such as Python, required.
- Prior experience developing reports and dashboards using Power BI or similar business intelligence tools (e.g., Tableau) required.
- Prior experience with both descriptive and predictive analytics is preferred.
- Experience in the healthcare preferred.
- PostgresSQL or similar applications experience
Knowledge/Skills/Abilities:
- Experience managing ADT/HL7/FHIR interfaces via Mirth Connect Engine a plus
- Experience with cloud services (AWS/Azure/Google) a plus
- Advanced knowledge of SQL, data modeling, and query optimization.
- Experience developing, validating, and troubleshooting ETL processes.
- Strong coding skills and the ability to automate tasks using Python, PowerShell, or other languages or tools.
- Excellent communication skills and the ability to collaborate with both technical and non-technical staff.
- The ability to learn new systems/tools as necessary.
- Understanding of how to gather requirements from end-users.
- Ability to troubleshoot and validate workflows.
Job Responsibilities
- Develop and maintain ETL processes for importing data into PostgreSQL from multiple data sources.
- Maintain and support cloud (AWS) database infrastructure.
- Identify and fix data quality issues using tools like SSIS, Python, or Tableau Prep.
- Develop new methods and streamline existing processes for collecting, storing, cleaning, validating, and visualizing data.
- Prepare documentation on all projects to enable peer review and ensure continuity of quality data products.
- Gather business requirements and develop dashboards and reports using Power BI or similar business intelligence tools such as Tableau.
- Triangulate and analyze complex clinical quality, financial, and operational data from multiple sources and markets in routine and ad hoc analyses. Analyze and translate data and trends into actionable findings for leadership to improve operations and the quality of various clinical services.
- Develop complex and accurate data models and assist in forecasting key metrics to inform business operations.
- Effectively communicate results and recommendations to a variety of audiences, including clinical and non-clinical staff, external stakeholders, and hospital administration.
- Follow data visualization best practices to produce effective operations and performance dashboards that tell meaningful stories.
- Work with external stakeholders to achieve their goals for clinical operations or provide explanations of data/trends as needed.
- Stay up to date on current data tools and industry trends, being willing to continuously improve technical skills.
- Other duties as assigned.
Location
Remote (occasional travel to Denver, CO or Salt Lake City, UT may be required)
Salary
$90,000-$120,000