Data Architect

You are an analytical, creative and a strategic thinker, who is passionate about designing and implementing data solutions. As a trusted leader, you will help to formulate an organizational data strategy, including standards of data quality, the flow of data within the organization, and security of data. You are a critical link between business and technology and can easily convert business requirements into technical requirements. As a key member of the team, you will be responsible for designing and implementing innovative database solutions that enable the organization to achieve our strategic objectives. You enjoy working closely with cross-functional teams to deliver data architecture solutions that align with business objectives and help to drive informed decision-making.

If this sounds like you, please read on!

The Data Architect will work in a fast-paced and dynamic hybrid association environment. The Data Architect will ensure the security, access, and performance of data systems and applications, aligning data architecture with overall enterprise architecture, and maintaining extensive knowledge of databases and their relation to business operations. The Data Architect will translate strategic requirements into a usable enterprise data framework and guide data solutions development while facilitating consistent data design, optimization, archiving, and recovery strategy.

The team includes a range of data engineers, data analysts, database administrator, focusing heavily on the AAOS registry projects. Some additional team members provide knowledge and support for the traditional TSQL, NOSQL(Cosmos) and ETL methods.

• Streamlines existing data architecture, delivering reusable services and cost saving opportunities in line with the policies and standards of the group. Ensures the end-to-end solution is fit for purpose, meets the needs of business, the agreed requirements, and are both pragmatic and supportive of the strategic architecture direction. Develops conceptual, logical, and physical data models to support data analysis and business intelligence.
• Evaluates and recommends emerging technologies for data management, storage, and analytics. Defines and manages standards, guidelines, and processes to ensure data quality. Ensures technology solutions are in alignment with data architecture principles and target state. Improves the way data assets are managed and works with the business to find new ways to monetize data.
• Provides centralized data services for Digital solutions teams – data scientists, full stack developers, data analysts, cloud, and BI team. Covers multiple data driven projects encompassing data requirements gathering, discovery, pipeline design, data modeling, and query tuning. While working independently, acts as the lead expert in data, and works with business analysts, project managers, architects, app developers and data engineers to deliver the results on time and with quality. Applies advanced consulting skills and extensive technical expertise with full industry knowledge. Develops innovative solutions to complex problems.
• Designs and creates custom data structures, stored procedures, views, indexes, and connections that facilitate the needs of data related initiatives and projects. Designs, maintains, and implements Disaster Recovery strategies for critical business servers. Develops and enforces database security standards and best practices including performance, security, monitoring policies and procedures. Conducts operational tasks in the administration of database systems and infrastructure ensuring that security, backup, and maintenance functional needs are met.

Exemplifies the following essential values of the Academy:

• Teamwork: Effective collaboration and team-focus to solve complex problems and drive innovation.
• Empowerment: The authority, information, and skills to make decisions and drive results.
• Accountability: Ownership of process and results that drive decisions and ensure implementation.
• Mindset of Growth/Continuous Learning: Focused on and invested in self and staff development to become more adaptable, making the Academy more agile, innovative, and sustainable.

Travel:

• Up to 15 days per year

Qualifications:

Required:

• Bachelor’s degree in computer science or engineering, with three years of professional experience working as a Database Engineer supporting complex data infrastructures.
• Very strong (10+ years) SQL experience writing queries within large-scale database environments.
• Experience with TSQL, NOSQL, OLTP, and OLAP Systems
• Working knowledge of SSAS cubes and architecture
• Proficient with Azure Data Factory, SSIS, Python for scripting and ETL automation
• Working experience with general DevOps, such as building infrastructure and CI/CD pipelines.
• Demonstrated knowledge of Microsoft technology stack, background in Azure Infrastructure as a Service environment desired
• Demonstrated knowledge of data models, data analytics, Azure Data warehouse, and cloud data architecture.
• Demonstrated experience with dimensional and relational modeling, establishing data structures for data marts and data warehouses, and supporting development teams with custom database needs.
• Applied knowledge of Microsoft Security/Authentication Concepts (Active Directory, IIS, Windows OS)
• Ability to implement, maintain, and troubleshoot big data infrastructures.
• Strong technical planning skills with the ability to prioritize and multitask across a number of work streams.
• Passion for continued improvement, learning and mentoring.
• Experience working in a business environment with demonstrated skills in report generation, ad hoc query tools such as Power BI or Tableau
• 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.
• Highly collaborative with the ability to manage and motivate project teams and meet deliverables.

Desired:

• Previous work experience with medical associations or not-for-profit organizations
• Previous work experience with Clinical Data Registries
• Knowledge of Big Data Programming languages such as Scala, R, Spark etc.
• Formal knowledge and experience with the CRM Systems (Salesforce, Dynamics 365) and Power Apps

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.

-Resumes must be accompanied by a cover letter with salary expectations to be considered.

Please note:

This position is based in either Rosemont, Illinois or Washington, D.C. and is open to applicants who are able to commute weekly to either office.

Applicants must already be authorized to work in the United States on a full-time basis. We are unable to sponsor or take over sponsorship of work visas.

JOB CODE: 1000053