The Data Engineer position is responsible for maintaining and enhancing the Registry’s data acquisition, integration and ETL pipelines in support of both operational and business intelligence data stores. This position is responsible for applying diverse data cleansing and transformation techniques as well as the ongoing management and monitoring of all AJRR databases. This includes addressing issues pertaining to the ongoing operations and optimization of the data environment including performance, reliability, logging, scalability, etc.
DUTIES AND RESPONSIBILITIES
Design, develop and maintain a high performance data platform in Microsoft Azure cloud based environment including the development of a data warehouse environment to support AJRR’s business intelligence roadmap
Design, develop and maintain the ETL pipelines using SSIS that standardize raw data from multiple data sources and optimize both the operational and dimensional/star schema data model necessary for transactional systems and business intelligence applications
Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions aligning to an overall data architecture
Extract, transform and load data to and from various data sources including relational databases, NoSQL databases, web services and flat files
Produce various technical documents such as ER diagrams, table schemas, data lineage, API documents, etc.
Provide complex analysis, conceptualize, design, implement and develop solutions for critical data-centric projects
Perform dataflow, system and data analysis and develop meaningful and useful presentation of data in downstream applications
Plan and implement standards, define/code conformed global and reusable objects, perform complex database design and data repository modelling
Monitor ETL processes, system audits, dashboard reporting and presentation layer functioning and performance. Pro-actively resolve issues as reported. Support the optimal performance of systems
Monitor database performance, provide optimization recommendations and implement recommendations
Follow the release cycles and implement on-time delivery of task assignments, defect correction, change requests and enhancements. Troubleshoot and solve technical problems.
Other responsibilities as assignment by management
Minimum of 3 years of relevant work experience in a data engineering role leveraging SQL, SSIS; including design and support of ETL routines that support the import of data from multiple data sources
Minimum of 3 years of data warehousing experience including the design, development and ongoing support of star or snowflake data schemas to support business intelligence applications
Minimum 5 years of database administration or database development experience in a SQL or MySQL environment; knowledge of Microsoft technology stack; background in Azure Infrastructure as a Service environment desired
Experience working with both structured and unstructured data
Demonstrated understanding of Business Intelligence and data solutions including cubes, data warehouse, data marts and supporting schema types (star, snowflake, etc)
Data modeling experience in building logical and physical data models
Performance tuning of SQL queries
Ability to build strong stakeholder relationships and translate complex technical concepts to non-technical stakeholders
Knowledge of SSRS, QlikView or QlikSense environments is a plus
Health Care industry experience a plus
Additional Salary Information: Benefits include health, dental and life programs. 401K retirement program.
The goal of the American Joint Replacement Registry (AJRR) is to foster a national center for data collection and research on total hip and knee replacement with far-reaching benefits to society including reduced morbidity and mortality, improved patient safety, improved quality of care and medical decision-making, reduced medical spending, and advances in orthopaedic science and bioengineering.
Copyright 2017 Colorado Society of Association Executives. This site content may not be copied, reproduced, or redistributed without the prior written permission of the Colorado Society of Association Executives.