Data Architect

Company: Matrix Medical Network
Location: Scottsdale
Posted on: April 9, 2021

Job Description:

Responsibilities:* Plan and participate in the execution of a migration plan from on-premise data to Azure platform * Design and develop standard dimensional data warehouse structures and data lakes.* Envisions and creates solutions that meet the data and analytical requirements of the business, models the required infrastructure and points of integration, creates data models and database designs, and provides the overall blueprint/roadmap for delivering the solution. * Creates and updates any design documentation required for development, and works collaboratively with BI, and IT Developer(s) to build the required components. * Works with the IT infrastructure, Application Development Teams, Data Engineers, Data Scientists, and Reporting Analysts to prove the feasibility of designs and ensure that solutions are designed for optimal access and leverage existing technologies where possible, and to identify any system-wide impacts that may need to be addressed. * Provides leadership in the creation of a mid/long-term BI roadmap to address any current gaps and move the company towards a future state architecture that easily scales to support future business growth and innovation.* Participates in all phases of SDLC: from system analysis and design thru development and test to deployment and support. * Provides development estimates and participates in project planning.* Responsible for ensuring quality delivery of code through static and dynamic testing techniques* Is able to troubleshoot any complex data related issues as well as provide support to production.* Keep abreast of the current technologies and technological trends. Ability to learn and prototype new technologies, and recommend their use in the company products. * Peer mentoring experience of more junior team members.* Ensures adherence to standards for self as well as team.* Other duties as assignedQualifications Must Haves: * Bachelor's degree in Computer Science or related field * Minimum 5 years experience with Azure platform, including Azure SQL, Data Factory, Databricks, and Data Lakes* Minimum 5 years of experience with data modeling and data architecture, including structured relational and DW models, and unstructured data such as JSON, XML, or NOSQL* Minimum 5 years of experience as a DB, SQL, or ETL Developer* Minimum 5 years of experience as a Lead or Senior Developer * Minimum 6 years of experience with Transact-SQL, Microsoft Power BI, Microsoft SQL Reporting Services, and Microsoft SQL Server(2014 or later preferred)* Minimum 6 years of experience with Microsoft SQL Server Integration Services (SSIS) or equivalent ETL platform* Minimum 2 years of experience with Tableau* Knowledge of advanced SSIS concepts to handle complex tasks like importing large files, loading data in a transactional database etc.* Experience in NoSQL databases is a big plus.* Strong Object / Relational mapping experience and ETL principles/knowledge* Experience in Database Administration with Oracle or SQL* Experience in object relational mapping, UML modeling and OO modeling* Proven ability to analyze, document, and reverse engineer any type of SQL\SSIS based code and ETL processes. * Make recommendation on how to rewrite, modify, redesign SQL and ETL based processes based on analysis.* Excellent written and verbal communication skills * Demonstrated experience of estimation and planning * Demonstrated abilities to successfully document and communicate software designs of complex systems.* Has proven record of successfully motivating and leading a software development team. * Proven history of developing and unit testing complex software components.* Ability to be flexible, set priorities and meet deadlines in a changing environment for self as well as team.* Must have decision-making skills for problem identification and solution recommendation. * Ability to work independently and as part of a team while demonstrating initiative and using good business judgment * Demonstrated ability to drive process improvement and improve the process efficiency* Demonstrated ability to reduce and/or prevent production defects based on the continuous root cause analysis and process improvement* Ability to maintain effective working relationships across teams and with a diverse workforce * Able to represent the Company in a positive and professional manner.Work Environment Our team is united by our mission to improve the accessibility of healthcare. Together, we tackle unique challenges that make each day more rewarding than the last. That's why we hire talented people with diverse backgrounds and skillsets.Our Culture : * We have a clear vision of where we are going, and we are guided by core values that embody our organization and our culture.* We emphasizes innovation and growth, and you will be given the opportunities and tools to develop personally and professionally.* We encourage and celebrate collaboration. * We have a deep commitment to positively impact the communities in which we work and to make a difference in the lives of who we serve.

Keywords: Matrix Medical Network, Scottsdale , Data Architect, Other , Scottsdale, Arizona