Data Engineer I

Job Description

About us:

AAAHC advocates for the provision of high-quality health care through the development and adoption of nationally recognized standards. We provide a valuable survey experience founded on a peer-based, educational approach to onsite review. The AAAHC Certificate of Accreditation demonstrates an organization’s commitment to providing safe, high-quality services to its patients—every day of the 1,095-day accreditation cycle.

Our offerings include:

Hybrid work schedule - in office Monday-Wednesday

Brand new, modern office setting

Complimentary snacks in the office

37.5 hour work week

Growth opportunities

Wellness programs

About the Role:

Reporting directly to the Assistant Director, Business Intelligence the Data Engineer, Business Intelligence is an important member of the BI team central to our ability to extract, transform and load data from AAAHC proprietary software applications generating useful data sets and designing dashboards, reports and data streams necessary to meet business requirements. This includes gathering and interpreting data requirements, research and analysis, business design, data mapping, partnering with technology to develop data flow, and performing business testing. This position will be exposed to multiple data sources to align information with the business of AAAHC.

Transform data into insight that can help to improve the value of the business—guide operations, inform and validate business decisions, and increase value for our clients and regulatory partners.

Determine data structure that integrates information from core operating systems—Accreditation Management System (AMS; legacy and new applications), Financial Management System (FMS), Learning Management System, and Website

Design and generate dashboards and ad hoc/routine reports through BI office applications and interfaces with AAAHC core systems that improve business processes and decisions for both AAAHC and our key clients. Transform AMS and other system data into reports and data streams that fulfill AAAHC contractual requirements/agreements for CMS, State agencies, and key client groups.

Collaborate with team members on translating business needs into data solutions including data collection/source identification, data selection criteria/filters, solution design, etc.

Define data values, manage obsolete data, and coordinate user access.

Organize data into appropriate file structures using defined standards.

Integrate multiple data structures into common interrelational database structures.

Validate that data structures are assembled and linked correctly.

Optimize data structures for efficient end-user querying and analysis.

Perform routine data analysis on large data sets.

Develop User instruction documentation for accessing data solutions.

Provide operational support in a variety of capacities including data integrity, quality assurance, monitoring, and reporting.

Support, monitor, and maintain data warehouse, monitor trends and performance.

Create and maintain documentation that includes design, requirements, report/dashboard standards, report generation processes, programming procedures and code for repeat usage, and BI user manuals for the organization

Minimum Qualifications and Job specific Competencies Required:

Bachelor’s Degree in Computer Science OR equivalent 4+ years’ experience in roles that demonstrate business analytics, project management, and coding proficiency

Superior research, analytical, planning, organizational skills, and detail-orientation

Ability to coordinate several tasks at one time and perform well under pressure; excellent time and project management

Ability to work independently, exercise mature professional judgment, and use discretion.

Minimum 2 years of demonstrated experience writing and troubleshooting T-SQL statements, and creating stored procedures, views, and SQL functions

Strong knowledge of Data Warehouse design techniques and a good understanding of Kimball data warehouse development methodologies

Experience designing, implementing, and optimizing data lakes, data marts, and star schemas, and a good understanding of related components and dependencies

Experience in logical and physical database design using relational database platforms including SQL Server and Oracle; demonstrated experience developing ETL/ELT packages using SQL Server Integration Services (SSIS) to bring large, complex data sets from various sources into a data warehouse

Demonstrated proficiency using data visualization tools (e.g., Microsoft Power BI, Tableau, Qlik, Cognos)

Customer service oriented

Advanced proficiency with Microsoft Office (i.e., Outlook, Word, Excel, PowerPoint)

Preferred Qualifications:

Project Management Professional (PMP)/PRINCE II Certification

Recent health care-focused experience

Knowledge of health care accreditation and the regulatory environment

Excellent Benefits Including:

At AAAHC, we prioritize attracting talented individuals who embody our core values of collaboration/communication, accountability, respect, and excellence. We understand the significance of balancing personal life with work commitments and hence offer a comprehensive benefits package to support our team. Our offerings include:

A robust health benefits package with generously subsidized medical insurance, including FSA and HSA options, complemented by dental and vision coverage

Assurance of financial security with company-paid benefits such as short and long-term disability, employee life, and Accidental Death and Dismemberment (AD&D) policies.

An annual discretionary bonus, enhancing your financial prospects

Generous paid time off that appreciates and rewards your loyalty and tenure with the company - start at 4 weeks/year

11 paid company holidays ensuring time for relaxation and family

Access to our Employee Assistance Program, supporting you in times of need

A 401(k) plan with a generous company contribution, supporting your future financial stability

The opportunity for hybrid work arrangements - in office Monday-Wednesday

Opportunities for continuous education, fostering personal growth and development

A "Dress for Your Day" policy, promoting comfort and individuality

Gym reimbursement, promoting wellness and health

Clear career advancement and growth pathways, recognizing your hard work and ambition

Rewarding employee referral bonuses for expanding our team

Public Service Loan Forgiveness (PSLF) eligible employer, enhancing financial wellness

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.