Working closely with the product and development teams, the Data Architect will analyze Q-Centrix business needs, and develop appropriate data deliverables, such as, data models, data flow diagrams, data dictionaries and glossaries to meet them. Data Architect will also assist in issue resolution, in operationalizing Data Governance, in assessing, measuring and tracking data quality, and in creating and socializing data management artifacts, such as, SOP’s, standards and guidelines, control processes etc. This role will be heavily involved in our overall data strategy and the implementation of the strategy across our existing data assets.

 

We’re looking for a Data Architect to partner with the Engineering and Business Intelligence teams from the Chicago, IL or San Diego, CA office. We would love for you to join our team if you love collaborating with a variety of people and have a knack for data.

  

The right candidate will embrace new and challenging work while building relationships with your fellow Q-Centrix associates. If asked, your colleagues would commend your commitment to improvement, strong work ethic, and passion for your work.

Get ready to…

• Provide data management expertise in evaluating requirements and developing data architecture and BI solutions that meet those requirements.  Data management includes appropriate structuring, stewardship of data, semantics/syntax of data attributes, coding structures, and mapping schemes.
• Design logical Data Warehouse architecture and data model, implement Data Warehouse design (schema, indexes, partitions, etc.)
• Develop technical architectures, designs, and processes to extract, cleanse, integrate, organize and present data from a variety of sources and formats for analysis and use across use cases.
• Design ETL architecture including CDC, mappings, data flows, procedures, schedules, etc.
• Design semantic layer based on the reporting requirements
• Design reporting architecture and provide recommendations for reporting technology
• Guide and coach engineers and BI analysts, share best practices, perform code reviews
• Coordinate activities with data source owners to ensure integration within data warehouse and that data integrity issues are pre-emptively addressed.
• Liaise and attend meetings necessary to perform duties and aid business and technical development.
• Work with source system and business SME’s to develop an understanding of the data requirements and options available within data sources to meet the data and business requirements.

You’re our ideal team member if you…

• Have 8 + years of hands-on professional experience and a bachelor’s degree
• Excellent organizational, verbal and written communication skills
• Very strong technical knowledge in ETL tools (e.g. SQL Server SSIS, Informatica Talend), RDMS (SQL Server, Postgres, Snowflake), OLAP tools (Microsoft SSAS), Reporting tools (Tableau, Power BI, Looker), ability to work alone or in conjunction with a team, similar technologies
• Certifications are a strong plus
• DBA skills and DB performance tuning knowledge a strong plus
• Working experience in AWS
• Good knowledge of standard methodologies, concepts, data modelling, best practices, and procedures within a Business Intelligence environment
• Creativity and flexibility in job role and working hours during critical deliveries
• Strong familiarity with Agile methodology
• A natural sense of urgency, initiative and is a positive team player to be reflected in daily      work ethics
• Experience working with Data Governance frameworks
• Strong experience performing conceptual and logical data model design
• Knowledge of SAS, Python, R or other statistical analysis software and its fit in the overall data architecture landscape

At Q-Centrix, we hire people who love learning, value innovation and believe in our mission and values to improve outcomes in healthcare. We applaud qualified applicants who are accountable and committed to producing quality work. As an Equal Opportunity Employer, we support and value diversity, dignity and respect in our work environment, and are committed to creating an inclusive environment in which everyone can thrive.

We employ people based on the needs of the business and the job, and their individual professional qualifications. Here’s what does not impact our employment decisions: race, religious creed, religion, color, sex, sexual orientation, pregnancy, parental status, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status, health, marital, civil union or domestic partnership status, or any status or characteristic protected by the laws or regulations in locations where we operate. If you are an individual with a qualified disability and you need an accommodation during the interview process, please reach out to your recruiter.

We celebrate and embrace these differences, and take pride in our commitment to being an equal opportunity team.