Contexture
Senior Data Analyst
Contexture, Denver, Colorado, United States, 80285
Job Code: SRDANLST
Reports To: Manager, Data Operations
Base Location: AZ or CO
Work Status: Virtual Office
Minimum Starting Monthly Range: $6,943
Hiring Range (Monthly Pay): $6,943 - $8,083
Full-time / Part-time: Full-time
Exempt / Non-Exempt: Exempt
Risk Designation: Extremely High
Summary
The Senior Data Analyst will work as part of the Data Acquisition, Transformation, and Analysis team to derive business value from enterprise data by implementing data analysis and reporting specifications provided by the Data Architect and Director of Data Acquisition, including data transformations, consumption, and automation. This role will work with multiple healthcare data sources and cross-functional teams to establish integrated datasets across legacy and greenfield data/platforms. You will work closely with data producers, consumers, and subject matter experts to enhance data service capabilities by implementing data architecture frameworks, standards, and principals, including modeling, metadata, security, and reference data.
This position is based in Phoenix Arizona, or Denver or Grand Junction Colorado. Our strategic flexibility allows local work from home opportunities.
Essential Duties and Responsibilities include the following:
Develop, implement, and maintain data analysis and reporting solutions for data business intelligence, reporting, visualization, and analysis
Support internal and external customers in data analysis and reporting activities, including data validation and in-depth analysis of source data
Assist with the development, implementation, and maintenance of enterprise data management solutions
Develop an expert understanding of internal enterprise data sources
Transform data using industry-standard techniques such as standardization, normalization, de-duplication, filtering, projection, and aggregation
Extract data from enterprise data sources as part of automated consumption data flows
Conduct research and evaluation of data analysis and data measurement methodologies, technologies, and tools and make recommendations for implementation
Prepare and present data analysis findings to internal and external stakeholders
Collaborate with data producers, consumers, and subject matter experts to ensure smooth dissemination and flow of data within the organization
Performs other related duties as assigned
Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Skills Demonstrated experience with relational and non-relational data storage models, schemas, and structures used in data lakes and warehouses for big data, business intelligence, reporting, visualization, and analytics
Hands-on experience with data extraction from data sources using analysis tools and programming languages, specifically Python and SQL
Ability to understand and analyze various data domains, including clinical, claims, social determinants of health (SDOH), financial, and operational data
Practical experience with industry-accepted standards, best practices, and principles for implementing well-designed data analysis and reporting solutions
Technical Skills and Experience:
Data processing experience in a production environment with terabyte-sized datasets that are both structured and unstructured data
Required Languages: Python and SQL
Required Libraries: PyData stack
Data storage experience with Microsoft SQL Server, MongoDB, and Snowflake
Leveraging data partitioning, parallelization, and data flow optimization principles
SQL query development using query planning and optimization techniques
File manipulation across varied file types, encodings, formats, and standards
Secure Software Development Lifecycle (SSDLC), version control, and release management
Knowledge of healthcare interoperability standards such as HL7 (Health Level 7), FHIR (Fast Healthcare Interoperability Resources), CDA (Clinical Document Architecture), etc.
Knowledge of healthcare clinical code sets such as LOINC, SNOMED, CPT, ICD-10, etc.
Strong understanding of project management disciplines such as Agile and Waterfall
Ability to translate technical requirements into actionable tasks for execution
Ability to work in a fast-paced and rapidly changing environment while consistently meeting strict service level agreement performance requirements
Ability to work independently as well as ability to effectively work in a team environment and maintain strong working relationships
Working knowledge of Microsoft Office 365 toolset (OneDrive, Word, Excel, and PowerPoint)
Education/Experience Minimum of 5+ years of experience working in data-related positions with increasing responsibility and scope of duties; specifically, 5+ years working with relational databases, 4+ years working with analytical data workloads. A Bachelor's Degree is required with a concentration in a data-related field such as Computer Science, Informatics, Mathematics, Engineering, etc. Master's Degree is preferred. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually moderate. The position may require occasional availability for after-hours work, outside of regularly scheduled hours. The position may require ability to periodically drive to and from clients, conferences and / or events; and / or limited travel. This position is expected to be exposed to, process, or handle sensitive information including but not limited to Protected Health Information (PHI), Personally Identifiable Information (PII), financial information, etc. As such, the holder of this position is expected to comply with all applicable laws, regulations, organizational policies, and compliance expectations. 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. The person in this position needs to frequently communicate and exchange information and move about inside the office to access file cabinets, office machinery, etc. Must be able to remain in a stationary position 50% of the time. Constantly operates a computer and other office productivity machinery, such as a keyboard, monitor, calculator, copy / scanner machine, and printer. Frequently moves office and work-related material weighing up to 10 pounds; Occasionally moves office and work-related material weighing up to 30 pounds. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Note:
This job description is not intended to be an exhaustive list of all duties, responsibilities and / or qualifications associated with the job. Benefits: The organization provides a comprehensive benefits package. For details, please request a Benefit Summary from Human Resources. The organization is an inclusive Equal Opportunity Employer. We do not discriminate on the basis of age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or other status protected by law or regulation.
Support internal and external customers in data analysis and reporting activities, including data validation and in-depth analysis of source data
Assist with the development, implementation, and maintenance of enterprise data management solutions
Develop an expert understanding of internal enterprise data sources
Transform data using industry-standard techniques such as standardization, normalization, de-duplication, filtering, projection, and aggregation
Extract data from enterprise data sources as part of automated consumption data flows
Conduct research and evaluation of data analysis and data measurement methodologies, technologies, and tools and make recommendations for implementation
Prepare and present data analysis findings to internal and external stakeholders
Collaborate with data producers, consumers, and subject matter experts to ensure smooth dissemination and flow of data within the organization
Performs other related duties as assigned
Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Skills Demonstrated experience with relational and non-relational data storage models, schemas, and structures used in data lakes and warehouses for big data, business intelligence, reporting, visualization, and analytics
Hands-on experience with data extraction from data sources using analysis tools and programming languages, specifically Python and SQL
Ability to understand and analyze various data domains, including clinical, claims, social determinants of health (SDOH), financial, and operational data
Practical experience with industry-accepted standards, best practices, and principles for implementing well-designed data analysis and reporting solutions
Technical Skills and Experience:
Data processing experience in a production environment with terabyte-sized datasets that are both structured and unstructured data
Required Languages: Python and SQL
Required Libraries: PyData stack
Data storage experience with Microsoft SQL Server, MongoDB, and Snowflake
Leveraging data partitioning, parallelization, and data flow optimization principles
SQL query development using query planning and optimization techniques
File manipulation across varied file types, encodings, formats, and standards
Secure Software Development Lifecycle (SSDLC), version control, and release management
Knowledge of healthcare interoperability standards such as HL7 (Health Level 7), FHIR (Fast Healthcare Interoperability Resources), CDA (Clinical Document Architecture), etc.
Knowledge of healthcare clinical code sets such as LOINC, SNOMED, CPT, ICD-10, etc.
Strong understanding of project management disciplines such as Agile and Waterfall
Ability to translate technical requirements into actionable tasks for execution
Ability to work in a fast-paced and rapidly changing environment while consistently meeting strict service level agreement performance requirements
Ability to work independently as well as ability to effectively work in a team environment and maintain strong working relationships
Working knowledge of Microsoft Office 365 toolset (OneDrive, Word, Excel, and PowerPoint)
Education/Experience Minimum of 5+ years of experience working in data-related positions with increasing responsibility and scope of duties; specifically, 5+ years working with relational databases, 4+ years working with analytical data workloads. A Bachelor's Degree is required with a concentration in a data-related field such as Computer Science, Informatics, Mathematics, Engineering, etc. Master's Degree is preferred. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually moderate. The position may require occasional availability for after-hours work, outside of regularly scheduled hours. The position may require ability to periodically drive to and from clients, conferences and / or events; and / or limited travel. This position is expected to be exposed to, process, or handle sensitive information including but not limited to Protected Health Information (PHI), Personally Identifiable Information (PII), financial information, etc. As such, the holder of this position is expected to comply with all applicable laws, regulations, organizational policies, and compliance expectations. 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. The person in this position needs to frequently communicate and exchange information and move about inside the office to access file cabinets, office machinery, etc. Must be able to remain in a stationary position 50% of the time. Constantly operates a computer and other office productivity machinery, such as a keyboard, monitor, calculator, copy / scanner machine, and printer. Frequently moves office and work-related material weighing up to 10 pounds; Occasionally moves office and work-related material weighing up to 30 pounds. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Note:
This job description is not intended to be an exhaustive list of all duties, responsibilities and / or qualifications associated with the job. Benefits: The organization provides a comprehensive benefits package. For details, please request a Benefit Summary from Human Resources. The organization is an inclusive Equal Opportunity Employer. We do not discriminate on the basis of age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or other status protected by law or regulation.