Job Description
The Senior Data Analyst will leverage cloud-based technologies and data lakes to provide insights and reporting on medical payer and patient data. You will be responsible for designing, developing, and maintaining data pipelines, ETL transformations, and data models that support MHK's business intelligence and analytics needs. You will also work with various stakeholders to understand their data requirements, provide data solutions, and deliver reports and dashboards using Power BI and Athena.
Key Responsibilities:
Extract, transform, and load data from various sources into a data lake using AWS services such as S3, Glue, Lambda, and Kinesis.
Create and optimize data models and schemas using AWS Athena and Redshift to support analytical queries and reporting.
Develop and maintain data quality checks and data governance processes to ensure data accuracy and integrity.
Create and update data dictionaries and metadata documentation to ensure data understanding and accessibility.
Design, develop, and test reports and dashboards using Power BI and Athena to meet business needs and specifications.
Collaborate with business users, data engineers, and data scientists to understand data requirements, provide data solutions, and support data-driven decision making.
Research and evaluate new data technologies and best practices to improve data performance and quality.
Provide technical guidance and mentorship to peers.
Skill Requirements: At least 5 years of experience in data analysis, data engineering, or business intelligence.
Strong knowledge and experience with AWS, Data Lake, ETL transformations, Athena, and Redshift.
Proficient in SQL and Python for data manipulation and analysis.
Experience with Power BI and other data visualization tools.
Experience with medical payer and patient data, such as claims, eligibility, enrollment, billing, and quality measures.
Excellent communication, presentation, and problem-solving skills.
Nice to have: Experience with Azure and Fabric.
Education/Certification Requirements: Bachelor's degree in Computer Science, Statistics, Mathematics, or related field.
Additional Requirements: Experience and ability to work in a constantly changing, fast paced, deadline driven environment.
All prospective employees must pass a background check & drug test (Federal contractor requirement)
COMMITMENT TO DIVERSITY & INCLUSION
We are an Equal Employment/Affirmative Action employer. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religion, creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state, or local law.
If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us by email at ******** . Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address and the email address cannot be used to inquire about the status of applications.
For more information, please visit Know Your Rights , Pay Transparency , and MHK EEO/AA Statement
Benefits Snapshot: Medical, vision, and dental plans for full time employees
401(k) offered with a generous match
Benefits begin on first day of the month following employment
Exercise/Health Club reimbursement opportunity
Monthly dependent care reimbursement opportunity
Short Term and Long Term disability
Basic Term Life and AD&D Insurance
Paid Time Off 15 days Paid Time Off
13 Company Paid Holidays
3 Personal Days
2 Community Service days
