Data Engineer

SUMMARY:

Services as a technical expert on our data layer. Discusses customer needs, maintains and updates databases, warehouse or marts. Tunes and ensures optimal database and server performance. Assists with reporting and analytics to meet business intelligence requirements and ensures overall integrity, quality and related system maintenance.

ESSENTIAL FUNCTIONS:

This class specification lists the major duties and requirements of the job and is not all-inclusive. Incumbent(s) may be expected to perform job-related duties other than those contained in this document and may be required to have specific job-related knowledge and skills.

• Discusses needs, operations and data requirements with staff or customers and outlines system capabilities and approaches to pull, maintain and analyze system data.
• Work with other data engineers to design and maintain scalable data models, tables, views and ETL pipelines
• Help design, build, and improve the infrastructure for ingesting, storing, securing and transforming data at a scale
• Re-assess current data environment and provide solutions, improving how we manage and use data for reporting.
• Clean up and establish best practices for developing new data tables and views. Simplify and build a design that is scalable, improving speed to execute and deliver reporting
• Help design and build systems to monitor and analyze data, responsible to create all data tables & views required for front end reporting
• Provide technology ownership for data solutions for projects that the team has been tasked with.
• Work with a cross functional team of business analysts, architects, engineers, data analysts to formulate technical requirements.
• Design and build data pipelines from various data sources to a target data warehouse using batch data load strategies utilizing cloud technologies.
• Conceptualizing and generating infrastructure that allows data to be accessed and analyzed effectively.
• Documenting database designs that include data models, metadata, ETL specifications and process flows for business data project integrations.
• Perform periodic code reviews and test plans to ensure data quality and integrity.
• Provide input into strategies that drive the team forward with delivery of business value and technical acumen.
• Execute proof of concepts, where appropriate, to help improve our technical processes.
• Provides analysis, interpretation and counsel regarding the application and usage of systems, business intelligence and reporting to improve policies, programs, and practices.
• Provides research and feedback to resolve management and customer questions and requirements; assists with receiving customer feedback and coordinating resources and responses as required.
• Analyzes and reviews operations, results, feedback, and related information on an ongoing to as needed basis to determine trends, draw conclusions, interpret findings, and presents results, proposals, and recommendations to management.
• Ensures the accuracy of operational databases, reports, and related details through audits, queries, and operational reviews; works with teams to resolve discrepancies.
• Interprets and applies department policies and procedures and assists with applicable laws, rules, and regulations; receives guidance within these areas as needed.
• Contributes to the efficiency and effectiveness of the department's service to its customers by offering suggestions and directing or participating as an active member of a work team.
• Performs other 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.

Need to Have:

• Bachelor’s Degree in Information Technology or related field and 5 years of related experience; or equivalent education and experience.
• Ability to work on site in our St Paul office 2-3 business days/week; parking reimbursement provided
• 4+ years of experience in managing data/databases (Proficient in SQL)
• 4+ years of experience in translating business requirements into technical data solutions on a large scale.
• "Can Do" attitude

Nice to Have:

• Prior experience working in a private equity-funded organization.
• Healthcare technology experience.
• Experience with Mirth or a similar integration or ETL tools
• Familariity with Tableau and Power BI

Required Knowledge and Skills

Required Knowledge:

• Research and troubleshoot potential issues presented by stakeholders within the data ecosystem.
• Experience with Data Modeling, Data warehousing
• Strong analytical and interpersonal skills.
• Ability and willingness to work as a team
• Enthusiastic, highly motivated and ability to learn quickly.
• Able to work through ambiguity in a fast-paced, dynamically changing business environment.
• Ability to manage multiple tasks at the same time with minimal supervision.
• Advanced principles, practices and techniques of managing data , databases and system analytics.
• Specialized understanding of data engineering, reporting and management.
• Understanding of the administration and oversight of data, system and business intelligence programs, policies, and procedures.
• Various methods to identify and resolve analytical problems, questions, and concerns.
• Basic methods and approaches to analyze and improve business operations.
• Understanding of applicable laws, codes, and regulations.
• Computer applications and systems related to the work.
• Principles and practices to serving as an effective project team member.
• Methods to communicate with staff, coworkers, and customers to ensure safe, effective, and appropriate operations.
• Correct business English, including spelling, grammar, and punctuation.

Required Skills:

• Building and maintaining ETL’s, ELT’s, marts, tables, views
• Performing advanced data engineering duties in a variety of assigned areas.
• Overseeing and administering business intelligence and data analytical systems.
• Using standard, customized, and complex data analytics tools.
• Training others in policies and procedures related to the work.
• Identifying, documenting, and reporting on system and data administration.
• Serving as a team member and the development and management of projects.
• Operating in both a team and individual contributor environment.
• Using initiative and independent judgment within established department guidelines.
• Contributing effectively to the accomplishment of team or work unit goals, objectives, and activities.
• Establishing and maintaining effective working relationships with a variety of individuals.

PHYSICAL/MENTAL REQUIREMENTS:

The physical demands described herein are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Mobility to work in an office setting, use standard office equipment and stamina to sit for extended periods of time; strength to lift and carry up to 10 pounds; vision to read printed materials and computer screens; and hearing and speech to communicate in person or over the telephone.

Travel as needed to support company and customer initiatives. Work on Site at our St Paul office may be required and ABOUT reserves the right to change the location of the role at any time.

This role may involve work on federal government contracts that require additional federal background investigations, training, and federal badging. As such, you will may required to submit personal information to the government and be fingerprinted and photographed at your local Department of Veteran Affairs Medical Center.

ABOUT is also an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

ABOUT offers a flexible, purpose-built solution that empowers hospitals and health systems to operate as one connected network of care. We enable easy access for clinicians to move patients into and out of the acute care setting - getting them to the next, best care setting faster and easier. Complemented by our clinical experts and best practices, we provide health systems the necessary controls and insights to grow with resilience, drive clinician effectiveness, and improve patient outcomes.