Job Title: Sr Data Engineer

Company Name: Air Methods

Job Details: $124k-$158k/yrRemoteFull,Time

Job Url: https://hiring.cafe/viewjob/znk2qwea1yyobobz

Job Description: Posted 1w agoSr Data Engineer@ Air MethodsView All JobsWebsiteGreenwood Village, Colorado, United States$124k-$158k/yrRemoteFull TimeResponsibilities:design models, build pipelines, mentor engineersRequirements Summary:Senior data engineer with 10+ years in data engineering, cloud experience (Azure, Snowflake), and leadership in mentoring others.Technical Tools Mentioned:Snowflake, Azure, Databricks, Power BI, SQL, Python, Spark, dbt, Matillion, NoSQL, Azure Data Factory
Overview:Job SummaryThe 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 extensibilityDevelop 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 scaleImplement and simplify self-service data query and analysis capabilities of the data platformEstablish and maintain standards and guidelines for design and development, tuning, deployment, and maintenance of information and advanced data analyticsMeet 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 processesActively mentor and lead knowledge sharing sessions, code, and design reviewsBuild conceptual and logical data models for stakeholders and managementActively lead knowledge sharing sessions, code, and design reviewsSupport the data platform infrastructure and implement solutions to ensure continuous improvement in platform stabilityCollaborate 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 algorithmsOther duties as assignedAdditional Job Requirements - This position is not eligible for sponsorship. Regular scheduled attendanceIndicate 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 ResponsibilitiesThis position has no supervisory responsibilities.          QualificationsTo 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 & ExperienceBachelor’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 experience10+ years in Data Engineering or related field5+ years working in a cloud computing environment, Azure preferredExtensive experience in building scalable data platforms in a cloud data platform, Snowflake preferredExtensive experience gathering data from multiple heterogeneous data sources, including databases, various file formats, and REST and SOAP APIsHands-on experience with Azure technologies, such as SQL and NoSQL databases, Azure DevOps, Azure Data Factory, Databricks, and Azure Analytics Services desiredStrong 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 planningSkillsAbility to lead and mentor other data engineersAuthoritative in ELT optimization, designing, coding, and tuning data processesExperience with building data pipelines and applications to stream and process datasets at low latenciesExperience in data mining, profiling, and analysisExperience with complex data modelling, ELT design, and using large databases in a business environmentDemonstrates efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability of dataAffinity for learning modern technologies, data analysis, and identifying data patterns and trendsProven ability to develop unconventional solutions; Sees opportunities to innovate and leads the wayDemonstrates 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-taskExcellent communication skills, both written and verbal Computer SkillsAdvanced experience with Microsoft Suite, including Word, Excel, PowerPoint, and Outlook Experience modeling data in cloud data platforms such as Snowflake, Redshift, and or BigQueryExperience with Python, Spark and PySpark desiredExpert in data architecture, ELT, and data ingestion development skillsAdvanced proficiency in writing complex SQL statements and manipulating large structured and semi-structured datasets.Experience with scheduling tools or a DAG schedulerExperience with cloud warehouse ELT tools (e.g., Matillion, dbt)Certificates, Licenses, RegistrationsNone 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 DisabilitiesThe 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)