Job Description: A Data Architect is responsible for designing relational and dimensional databases. The Data Architect applies relational theory and business process analysis to the development of logical data models and converts these logical models into physical database objects using data modeling CASE tools. The position develops and implements enterprise-level strategies and principles for the integration of enterprise information resources by defining corporate standards for data architecture, format, quality, and database design. The Data Architect is also responsible for the design, development, and implementation of ETL processes. The Senior Level Data Architect independently manages projects that are moderate to large in complexity. Also responsible for the mentoring of junior staff and the validating of the analysis, models, and data conversion and quality assurance processes of junior data architects. The Senior Data Architect provides input and leadership to help define best practices and standards in database design and business intelligence solutions. Works closely with leadership and customers at the corporate level of the organization to develop integrated and standardized business intelligence solutions. Job Essentials Records detailed logical and physical data models in the information repository and coordinates the publication and maintenance of these models. Ensures appropriate integration of models and designs across the enterprise. Facilitates database design sessions and translates business requirements into logical and physical system designs for moderate to large complex projects. Leads the physical database design and implementation process for moderate to largely complex projects. Designs the optimal data presentation environment for the customer and works with various reporting tools. Coordinates with specific database performance monitoring and tuning tasks including the design of optimization and indexing schemes for moderate to large complex projects. Develops, tests and implements moderately complex ETL (extract, transformation, and load) routines. Documents business requirements and essential functionality requirements for in-house developments and the selection of third-party applications. Assists in leading the effort to ensure proper integration with existing Intermountain data, standards, and business processes. Provides leadership for moderate to large complex projects through development of project work plans, recommendations for optimal utilization of resources, milestone tracking, and coordination of project team efforts. Keeps management and customers informed of progress and exceptions. Leads the development and implementation of system backup, recovery, and support plans. Addresses the customer needs, manages expectations and ensures system-wide integration. Participates in the technical review process of designs completed by other designers and serves as a mentor to junior designers. Develops, documents, and delivers complex ad-hoc queries of production data as requested by business users. Consults with the business users that are performing queries. Works effectively with clients and staff to determine needs, specifications, feasibility, and project priorities. Maintains advanced understanding of industry application development methodologies, tools and techniques. Leads the definition of and subsequently follows enterprise and department-specific standards and methodologies. Leads projects and understands the differences between On-line Transaction Processing and Decision Support systems and how to appropriately support the requirements and environments for each. Minimum Qualifications Bachelor's degree. Degree must be obtained through an accredited institution. Education is verified. 3-5 years experience in database design, development, and business intelligence technologies. Advanced knowledge of SQL (structured query language). Demonstrated high degree of flexibility and motivation in an aggressively changing environment. Demonstrated interpersonal communication skills to promote and advance business intelligence in collaboration with our customers. Demonstrated project management skills, customer service skills, as well as demonstrated organizational skills. Demonstrated ability to deal with highly sensitive and confidential material and adher to data security and confidentiality protocols and procedures. Demonstrated knowledge of healthcare concepts including patient care and healtcare financing. Demonstrated knowledge of basic information used in a healthcare environment and how the data is produced, consumed and transformed. Demonstrated knowledge of advanced data warehousing concepts. Preferred Qualifications Experience with Databricks, Apache Spark, and Delta Lake for real-time and batch data processing. Proficiency in data streaming technologies such as AWS Kinesis or Azure Event Hubs. Experience working with APIs to retrieve and integrate data from external systems. Experience developing APIs to provide data as a product. Familiarity with programming languages such as Python and PySpark for data engineering tasks. Strong knowledge of ETL/ELT processes and tools, including both traditional (e.g., SSIS, Informatica) and cloud-native solutions (e.g., Azure Data Factory, Databricks). Excellent communication skills for collaborating with stakeholders and teams. Physical Requirements: Location: SelectHealth - Murray Work City: Murray Work State: Utah Scheduled Weekly Hours: 40 The hourly range for this position is listed below. Actual hourly rate dependent upon experience. $53.58 - $84.36 We care about your well-being mind, body, and spirit which is why we provide our caregivers a generous benefits package that covers a wide range of programs to foster a sustainable culture of wellness that encompasses living healthy, happy, secure, connected, and engaged. Learn more about our comprehensive benefits packages for our Idaho, Nevada, and Utah based caregivers (https://intermountainhealthcare.org/careers/working-for-intermountain/employee-benefits/) , and for our Colorado, Montana, and Kansas based caregivers (http://www.sclhealthbenefits.org) ; and our commitment to diversity, equity, and inclusion (https://intermountainhealthcare.org/careers/working-for-intermountain/diversity/) . Intermountain Health is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. All positions subject to close without notice.

Senior Data Architect (Principal Enterprise Architect) - Remote R0038318 We are looking for a Senior Data Architect (Principal Enterprise Architect) to collaborate with different divisions and create a coalition/task force to reverse engineer products and look for inefficiencies. As a Senior Data Architect (Principal Enterprise Architect), you will partner with several teams to look for performance improvement opportunities, stabilize multiple products and give constructive input to develop a long-term relationship and partnering. Provide expertise in deploying an organization's data architecture. This is a remote role and will report to the Director, Database Analysis & Development and under the leadership of the VP, IT Infrastructure & Operations. LI-Remote Required Job Qualifications (Minimum): Experience: 5- 7 years of experience of hands-on experience as an Enterprise Architect, Principal Engineer, or similar role for large-scale enterprise solutions using agile practices. Experience with both development and infrastructure efforts in a large matrix organization. 10 years of experience Architecting on Azure 5 years of proven experience in application architecture, Cloud Solutions with emerging technologies, Big Data, Data Modeling, Data Architecture, Data Warehousing and Business Intelligence. Experience with provisioning and managing infrastructure and applications in Azure environments. Expert in reverse engineering database code for performance tuning. Demonstrate an advance ability to manage large datasets, cloud computing, open-source tools, and optimization techniques. Understanding of modern data architecture and experience with core data services like maintaining data lakes, data warehouses, data marts and relational and dimensional modeling, data quality and master data management. Experience designing data architectures to define and deliver data as an asset. Experience in Dimensional Modeling (Star Schema, OLAP Cubes, and Bus Matrix Mapping) Experience with the design, deployment, and evaluation of tools, frameworks, and patterns to build scalable data platforms. Experienced industry-leading data infrastructure technologies and end user tools. Experience troubleshooting data issues and identifying causes of performance bottlenecks. Experience with SQL Server databases, Oracle, Postgres, MySQL relational data models and best practice architectural concepts. SQL development skills using SQL, T-SQL, PL/SQL, stored procedures Experience with Agile software development Experience with Azure DevOps (ADO) or Jira Must be legally authorized to work in the USA. Other Qualifications (preferences): Experience: 3 years of experience creating high-quality data pipelines. 3 years of experience bringing people together across teams to collaborate on solutions. 3 years of experience growing people and teams through modeling, coaching, and demonstrating care. Working knowledge of Azure data platform data factory, data catalogs, data lake, analytics, Azure storage options, Azure SQL, Cosmos DB, Azure DevOps, etc. Education : Bachelor's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 6 years experience in business analytics, data science, software development, data modeling or data engineering work Master's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 4 years experience in business analytics, data science, software development, data modeling or data engineering work OR equivalent experience. Azure: Architecture Certifications Essential Responsibilities: You will develop data architecture principles, creates models of data that enable the implementation of the intended business architecture, creates diagrams showing important data entities, and creates an inventory of the data needed to implement the architecture vision. Expresses strategic data requirements, outlines high-level integrated designs to meet these requirements, and aligns with enterprise strategy and related business architecture. Define how data are managed by different data entities and IT systems, and any applications using or processing that data. Provide guidance for infrastructure and software architecture and planning. Identify and guide development of data standards. Additional Information: Wolters Kluwer offers great benefits and programs to help meet your needs and balance your work and personal life, including: Medical, Dental, & Vision Plans, 401(k), FSA/HSA, Commuter Benefits, Tuition Assistance Plan, Vacation and Sick Time, and Paid Parental Leave . Full details of our benefits are available - https://www.mywolterskluwerbenefits.com/index.html Wolters Kluwer (EURONEXT: WKL) is a global leader in professional information, software solutions, and services for the healthcare, tax and accounting, financial and corporate compliance, legal and regulatory, and corporate performance and ESG sectors. We help our customers make important decisions every day by providing expert solutions that combine deep domain knowledge with specialized technology and services. Wolters Kluwer reported 2022 annual revenues of 5.5 billion. The group serves customers in over 180 countries, maintains operations in over 40 countries, and employs approximately 20,000 people worldwide. We are headquartered in Alphen aan den Rijn, the Netherlands. Ranked by Forbes Magazine as among Americas Best Large Employers for 2022 - 84 . Wolters Kluwer secures 2nd place in Newsweek's Most Trustworthy Companies List 2023 CEO Nancy McKinstry ranked 16th by Harvard Business Review of the best performing CEOs in the World. WK 1 for gender equality in the workplace in the Netherlands & 47 worldwide for 2023 . Diversity Matters Wolters Kluwer strives for an inclusive company culture in which we attract, develop, and retain diverse talent to achieve our strategy. As a global company, having a diverse workforce is of the utmost importance. We've been recognized by employees as a European Diversity Leader in the Financial Times, as one of Forbes Americas Best Employers for Diversity in 2022, 2021 and 2020 and as one of Forbes Americas Best Employers for Women in 2021, 2020, 2019 and 2018. In 2020, we placed third in the Female Board Index, and were recognized by the European Women on Boards Gender Diversity Index. Wolters Kluwer and all of our subsidiaries, divisions and customer/departments is an Equal Opportunity / Affirmative Action employer. The above statements are intended to describe the general nature and level of work being performed by most people assigned to this job. Theyre not intended to be an exhaustive list of all responsibilities and requirements. The job description provided is subject to revision and modification at any time. EQUAL EMPLOYMENT OPPORTUNITY Wolters Kluwer U. S. Corporation and all of its subsidiaries, divisions and customer/business units is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

This is a remote position that may require you to come onsite occasionally to collaborate with other teams. ABOUT THE POSITION As the Principal Data Architect, you will own the data model/schema in support of CSC's analytics initiatives.In this role, you will be the owner of the Data & Analytics data assets.You will determine appropriate modeling standards and develop processes to ensure compliance with these patterns.The responsibility of this role will span components in Azure Data Lake, Azure Synapse Data Warehouse, and Azure Analysis Services. HOW YOU WILL MAKE A DIFFERENCE Work closely with delivery teams and subject matter experts to deliver data warehousing solutions that are reliable, flexible, scalable, and provide low-cost ownership. Participate in the design, development, documentation, and application of best practices and procedures that govern the implementation of data assets. Roadmap newanalytic capabilities and technologies to be evolved and adopted. Partner with Enterprise Architecture on enterprise strategy Provide technical mentoring, guidance, and training to Data and Analytic engineering resources. YOU ARE Able to envision a strategy, communicate and promote, and then dive in to help others achieve the vision An excellent communicator that can document and present complex technical information in a clear and concise manner to a variety of audiences Highly structured with the ability to organize others around you A creative thought leader that is consultative in their approach YOU HAVE 5 years of experience delivering data centric solutions on warehousing, big data, and cloud platforms 3 years of experience design and tuning a MPP environment 3 years of experience with an Enterprise Reporting Suite (preferred PowerBI, Analysis Services) Expert SQL and query optimization techniques Expert data modeling techniques LI-JD1 This job description is not meant to be an all-inclusive list of duties and responsibilities, but constitutes a general definition of the position's scope and function in the company. Columbia Sportswear is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. The Know Your Rights poster is available here: https://www.eeoc.gov/poster The pay transparency policy is available here: https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf Columbia Sportswear is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process, please notify your recruiter. At Columbia Sportswear Company, we're proud to offer regular full-time employees a benefits package that includes a variety of services and products to help make your life and work more rewarding. Our benefit programs contribute to overall employee well-being by aligning those programs with the fundamental elements of well-being: physical, social/emotional, financial, career and community. Benefits that can protect your family's financial future and help you save money through our 401k plan plus a generous company match. Columbia offers medical, dental, vision, life Insurance, disability, flexible spending accounts, health savings account, and an assortment of voluntary benefit offerings (accident, critical illness, hospital indemnity, and legal services). In addition, Columbia offers EAP which is free and confidential 24/7/365 counseling services. We have extensive wellness benefits, employee discounts and a generous time off program available. If you need an accommodation/adjustment to successfully complete and submit your application, please reach out to AskHRcolumbia.com with the Subject: Applicant Assistance Requested.

Data Architect Jobs in Turner, OR

Senior Data Architect Principal Enterprise Architect Remote
November 5, 2024

Data Architect
October 31, 2024

Senior Data Architect Principal Enterprise Architect Remote
October 31, 2024

Data Architect Life Sciences Sector Senior Manager Consulting Location Open
October 31, 2024

Data Architect Industrial Energy Sector Manager Consulting Location Open
October 31, 2024

Data Architect Life Sciences Sector Senior Manager Consulting Location Open
October 30, 2024

Data Architect Data Modeler Remote
October 27, 2024

Quick filters

Top companies

Data Architect Jobs in Turner, OR

Senior Data Architect Principal Enterprise Architect RemoteNovember 5, 2024

Data ArchitectOctober 31, 2024

Senior Data Architect Principal Enterprise Architect RemoteOctober 31, 2024

Data Architect Life Sciences Sector Senior Manager Consulting Location OpenOctober 31, 2024

Data Architect Industrial Energy Sector Manager Consulting Location OpenOctober 31, 2024

Data Architect Life Sciences Sector Senior Manager Consulting Location OpenOctober 30, 2024

Data Architect Data Modeler RemoteOctober 27, 2024