Data Architect #14177 | Medica | MN-Minnetonka

Data Architect #14177 | Medica | MN-Minnetonka

Data Architect-14177

 

What you'll get to do:

Medica's Technical Architect is a hybrid position as compared to larger shops in the industry. It combines the role of architect, consultant, troubleshooter, extract, transform and load (ETL), application developer and EAI expert into a single position. However depending on the domain (Application, Data, System, Security), level of expertise may vary.

• Define, analyze, and review architecture and technical requirements
• Involve and recommend enterprise’s server hardware, operating system for the enterprise data warehouse
• Participates in the drafting of Service Level Agreements (SLA)
• Lead a team of developers and mentor junior team members
• Involve in enterprise application integration (EAI). This includes defining the opportunities for integration, selecting the tools, specifying the shared data & code resources, defining the interfaces and data-flows, and monitoring the success of said integration
• Responsible for defining the application tiers, frameworks, components types and interfaces. Also, creates the first-draft graphical template of UML design models used by the Project Architects
• Specifies and provides ownership of reusable application components or reusable application code
• Sets Data Policy and the technical solution for the management, storage, access, navigation, movement, and transformation of data
• Specifies recommended DBMS and ETL tools and technologies for structured and unstructured content
• Reviews the policies and work of the Data Base Administrators
• Provide framework, stewardship, governance, and decision making for the management of enterprise data for project development teams, business users and other stake-holders
• Balance short-term versus long-term actions, strategic versus tactical requirements, while continuing to move forward towards the strategic vision; participate in the road map to achieve the vision
• Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise
• Provide architectural solutions covering data structures, sourcing, integration, security, and retention
• Define governance and best practices around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and consistent definitions for common reference data
• Elicit requirements and translate the requirements into models by building conceptual, logical and physical data models
• Involve in data roadmap, current / target state for enterprise data

Qualifications:

• Bachelor's Degree in Computer Science or related field preferred, equivalent relevant work experience considered
• Masters Degree is a plus
• 10 years of related experience required, 12 years+ preferred  

Specific types of experience:

• Experience in data analysis, data profiling, data integration, and data quality
• Provide framework, stewardship, governance, and decision making for the management of enterprise data for project development teams, business users and other stake-holders
• Balance short-term versus long-term actions, strategic versus tactical requirements, while continuing to move forward towards the strategic vision; participate in the road map to achieve the vision
• Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise
• Provide architectural solutions covering data structures, sourcing, integration, security, and retention
• Experience in data analysis, data profiling, data integration, and data quality
• Define governance and best practices around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and consistent definitions for common reference data
• Experience in tuning DataWarehouses
• Extensive experience in creating data warehouses, data marts, and modeling (3NF and dimensional)
• Data modeling experience creating both dimensional and relational models; ERWIN experience is preferred
• Advanced knowledge of SQL, database performance, RDBMS, and Query tools
• Prior experience in ETL, reporting and analytics, and business intelligence tools is preferred
• Prior experience in health care domain is preferred
• CBIP (certified business intelligence professional) from TDWI is nice to have

Skills and Abilities:

• Ability to evaluate, analyze, design and implement solutions based on technical requirements
• Ability to identify solutions to complex problems and business processes using tools and technologies to improve efficiency through automation, re-use, design patterns, and best practices
• Strong verbal and written communication skills including interpersonal skills
• Ability to communicate to a variety of audiences in both verbal and written form
• Ability to collaborate with all levels of a complex organization to meet the needs of business and IT
• Ability to deal effectively in a team environment and provide project direction and counsel, provide recommendations to senior management, and collaborate beyond the immediate project team to meet the needs of business
• Excellent oral, written, and communication skills
• Excellent problem solving skills 

https://medica.taleo.net/careersection/2/jobdetail.ftl?job=14177