Data Engineer

Apply for this Position

Application Form     (* indicates required field)

Please attach the following files

Please upload either a word or PDF version of your cover letter for this position.
Please upload either a word or PDF version of your current resume.
Such as letters of recommendation, work examples, etc.

I certify that all the information submitted by me is true and complete, and I understand that if any false information, omissions, or misrepresentations are discovered, my candidacy may be rejected and, if I am employed, my employment may be terminated at any time. I authorize the American Academy of Orthopaedic Surgeons (AAOS) to conduct employment reference checks. I understand that I may request that AAOS share with me the nature and substance, but not the source of the information so provided.

You must agree to the disclosure statement provided in order for us to accept your application.

You will receive confirmation after we have received your application.

You are known for your development and deployment of innovative big data platforms for advanced analytics and data processing. You lead innovation through exploration, benchmarking, making recommendations, and implementing big data technologies for platforms. You are excited by defining and building data pipelines that will enable faster, better, data-informed decision-making within the business. You have a passion for continued improvement, learning and mentoring, and leverage this enthusiasm when building stakeholder relationships. You are collaborative, insightful and want to work for an organization making a difference in the field of orthopaedics on behalf our members and their patients.

If this sounds like you, read on!   

The Data Engineer is primarily responsible for maintaining and enhancing the Registry’s data acquisition, integration, and ETL pipelines in support of both operational and business intelligence data stores. The incumbent is responsible for applying diverse data cleansing and transformation techniques as well as the ongoing management and monitoring of all Registry databases. This includes addressing issues pertaining to the ongoing operations and optimization of the data environment including performance, reliability, logging, scalability, etc. This position will also provide support for the Academy’s database systems, warehouse, marts, and supporting applications.  

Lead the effort to develop a unified enterprise data model for the Academy. Design, develop, and maintain high-performance data platforms on premise and in Microsoft Azure cloud-based environments including leading the development of a data warehouse environment to support the Registry’s business intelligence roadmap. Champion efforts that will ensure that the Academy’s business intelligence applications remain relevant for use by internal business groups by actively participating in strategy and project planning discussions. Work collaboratively with Registry participants and internal support teams, identify and implement changes that improve system performance and the user experience.

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 leadership and oversight on database architectural design for existing Academy systems including database administration, performance monitoring, and troubleshooting. 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. Proactively identify and implement procedures that resolve performance and/or data reporting issues. Support the optimal performance of the Academy’s data and BI 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. Perform other responsibilities as assignment by management.

Required Qualifications:

  • Bachelor’s degree in Computer Science, Information Systems, Business Administration, or other related field required

  • 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 2 years of experience with PowerBI

  • 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

  • Applied knowledge of Microsoft Security/Authentication Concepts (Active Directory, IIS, Windows OS)

  • Strong technical planning skills with the ability to prioritize and multitask across a number of work streams

  • Must have a passion for continued improvement, learning, and mentoring

  • Polished presentation skills; experience creating and presenting findings to executive level staff

  • Strong written, verbal and interpersonal communication skills, with an ability to communicate ideas and solutions effectively

  • Must be highly collaborative with the ability to manage and motivate project teams and meet deliverables

  • Ability to build strong stakeholder relationships and translate complex technical concepts to non-technical stakeholders

  • Experience with Data Warehouse is a plus

  • Knowledge of SSRS is a plus

  • Healthcare industry experience a plus 

If this describes YOU, please apply by sharing the following:   

-Clearly communicate why you are the ideal candidate for this role, providing specific examples and experiences as proof points.

-Attach your resume, cover letter and any additional materials that support your application.   

-Salary expectations must be included to be considered for this opportunity.   

Location: Rosemont, IL
Apply for this Position Job code: HR/DER
Apply at: