Sr Data Engineer

Overview

Job Summary

The Senior Data Engineer at Air Methods is responsible for leading and growing our data-driven decision culture by designing, developing, and delivering data engineering and analytical solutions that are customer focused, easy to consume and create business impact. To be successful, this teammate must have a passion for mentoring other data engineers and working with stakeholders to understand their needs and deliver value through the entire data pipeline. You will design and implement complex data models, model metadata, build data pipelines, reports and dashboards, and own data presentation and dashboarding tools for the end users of our data products and systems.

You will write scalable, highly tuned SQL queries and will develop learning and training programs to drive adoption of data driven decision making across the organization.

Essential Functions and Responsibilities include the following:  

Develop and improve the current data architecture, emphasizing data security, data quality and timeliness, scalability, and extensibility

Develop and implement complex and efficient data pipelines/solutions to transform raw data sources into powerful, reliable components of our data platform and business insights 

Deploy and use various data and big data technologies and run pilots to design low latency data architectures at scale

Implement and simplify self-service data query and analysis capabilities of the data platform

Establish and maintain standards and guidelines for design and development, tuning, deployment, and maintenance of information and advanced data analytics

Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business and develop an understanding of how their data supports their business processes

Actively mentor and lead knowledge sharing sessions, code, and design reviews

Build conceptual and logical data models for stakeholders and management

Actively lead knowledge sharing sessions, code, and design reviews

Support the data platform infrastructure and implement solutions to ensure continuous improvement in platform stability

Collaborate with business analysts, data scientists, product owners, software development engineers, and other teams to develop, implement, and validate KPIs, statistical analyses, data profiling, prediction, forecasting, clustering, and machine learning algorithms

Other duties as assigned

Additional Job Requirements - This position is not eligible for sponsorship. 

Regular scheduled attendance

Indicate the percentage of time spent traveling - 0%

Subject to applicable laws and Air Method’s policies, regular attendance is an essential function of the position.  All employees must follow Air Methods’ employment practices and policies.

Supervisory Responsibilities

This position has no supervisory responsibilities.          

Qualifications

To perform this job successfully, an individual must be able to perform each essential function satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.  In accordance with applicable laws, Air Methods will provide reasonable accommodations that do not create an undue burden so disabled employees may perform the essential functions of the position.

Education & Experience

Bachelor’s degree (BS/BA) from four-year college or university in Information Computer Science or related field, and eight+ years’ related experience and/or training; or equivalent combination of education and experience

10+ years in Data Engineering or related field

5+ years working in a cloud computing environment, Azure preferred

Extensive experience in building scalable data platforms in a cloud data platform, Snowflake preferred

Extensive experience gathering data from multiple heterogeneous data sources, including databases, various file formats, and REST and SOAP APIs

Hands-on experience with Azure technologies, such as SQL and NoSQL databases, Azure DevOps, Azure Data Factory, Databricks, and Azure Analytics Services desired

Strong experience with Data Visualization Tools (Power BI preferred)

Strong experience in an Agile Scrum environment, with work estimation and providing input to managers on resource and risk planning

Skills

Ability to lead and mentor other data engineers

Authoritative in ELT optimization, designing, coding, and tuning data processes

Experience with building data pipelines and applications to stream and process datasets at low latencies

Experience in data mining, profiling, and analysis

Experience with complex data modelling, ELT design, and using large databases in a business environment

Demonstrates efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability of data

Affinity for learning modern technologies, data analysis, and identifying data patterns and trends

Proven ability to develop unconventional solutions; Sees opportunities to innovate and leads the way

Demonstrates high critical thinking and reasoning skills and strong attention to detail while working in a fast-paced environment that requires ability to prioritize and multi-task

Excellent communication skills, both written and verbal 

Computer Skills

Advanced experience with Microsoft Suite, including Word, Excel, PowerPoint, and Outlook 

Experience modeling data in cloud data platforms such as Snowflake, Redshift, and or BigQuery

Experience with Python, Spark and PySpark desired

Expert in data architecture, ELT, and data ingestion development skills

Advanced proficiency in writing complex SQL statements and manipulating large structured and semi-structured datasets.

Experience with scheduling tools or a DAG scheduler

Experience with cloud warehouse ELT tools (e.g., Matillion, dbt)

Certificates, Licenses, Registrations

None

Air Methods is an EEO/AA employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

Minimum pay
USD $124,000.00/Yr.
Maximum Pay
USD $158,000.00/Yr.
Benefits

For more information on our industry-leading benefits, please visit our benefits page here. 

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)