Data Engineer (Hybrid MN , W2)
Apply on
: -
@.
:
Location: Hybrid St. Paul, MN (must be onsite 2-3 days, parking reimbursement provided)
The resource will need to be a , , or and communication is SUPER important.
:
5 ; .
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
Healthcare (HL7) Data experience
Steaming experience (Kafka)
AWS Firehose to the Data Lake
:
Prior experience working in a private equity-funded organization.
Healthcare technology experience.
Experience with Mirth or a similar integration or ETL tools
Familiarity with Tableau and Power BI
Position Overview: 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.
:
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
:
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.
:
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.
