ScottsdaleRecruiter Since 2001
the smart solution for Scottsdale jobs

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Amazon Picker/Packer (Day Shifts Available)
Description: div style 'display:flex border:0px solid black important flex-direction:column ' div style 'display:flex width:100 ' div style 'flex:1 border:0px solid black important ' div class sfdc richtext (more...)
Company: Amazon
Location: Maricopa
Posted on: 04/14/2021


Description: div style 'display:flex border:0px solid black important flex-direction:column ' div style 'display:flex width:100 ' div style 'flex:1 border:0px solid black important ' div class sfdc richtext (more...)
Company: Amazon
Location: Maricopa
Posted on: 04/14/2021

Now Hiring Nanny Needed For 1 Child
Description: We need a nanny for our 1 child in
Company: Care.com
Location: Buckeye
Posted on: 04/14/2021


Service Solutions Group - Research and Resolution Team - Greater Phoenix, AZ
Description: Job Description:We have a new and exciting opportunity for a Remote Licensed Service Support Specialist in the Greater Phoenix area The position is fully remote and requires you reside in the Greater (more...)
Company: Fidelity Investments
Location: Sun City
Posted on: 04/14/2021

Amazon Picker/Packer (Immediate Openings) - Earn up to $17.40/hr
Description: div style 'display:flex border:0px solid black important flex-direction:column ' div style 'display:flex width:100 ' div style 'flex:1 border:0px solid black important ' div class sfdc richtext (more...)
Company: Amazon
Location: Maricopa
Posted on: 04/14/2021

Small Animal Vet
Description: Our family of animal hospitals is in search of Experienced Veterinarians OR students in their 3rd or 4th year of the DVM program, on track to graduate Interview virtually immediately no need to wait (more...)
Company: AZPetVet
Location: Buckeye
Posted on: 04/14/2021

Make up to $18/hour - Deliver with DoorDash - Start Delivering Today
Description: Your time. Your Goals. What is DoorDash Available in over 4,000 cities in the U.S., Canada, and Australia, DoorDash is about connecting people with possibilities: bigger savings accounts, wider nets, (more...)
Company: DoorDash
Location: Prescott Valley
Posted on: 04/14/2021

Special Warfare Combatant-Craft Crewmen
Description: ABOUT br br Special Warfare Combatant-Craft Crewmen SWCC are specially trained to operate on and around rivers and coastal regions around the world. Wielding extreme firepower and a deadly skill (more...)
Company: Navy
Location: Sun City
Posted on: 04/14/2021

92G Food Service Specialist (Buckeye,AZ)
Description: Job Description br br It takes energy to keep the Army National Guard marching on, and that's where you take the lead. As a Food Service Specialist for the Guard, it's your duty to provide the sustenance (more...)
Company: Army National Guard
Location: Buckeye
Posted on: 04/14/2021

Amazon Picker/Packer (Immediate Openings)
Description: div style 'display:flex border:0px solid black important flex-direction:column ' div style 'display:flex width:100 ' div style 'flex:1 border:0px solid black important ' div class sfdc richtext (more...)
Company: Amazon
Location: Maricopa
Posted on: 04/14/2021

Log In or Create An Account

Get the latest Arizona jobs by following @recnetAZ on Twitter!

Scottsdale RSS job feeds