<p>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.</p>

<p>Client: State of Pennsylvania Title: Senior Data Architect Location: Remote - EST Hours (8:30 AM EST standing meeting) Duration: 18 months Target Start Date: June 19, 2023 Senior Data Architect Job Overview The Commonwealth of PA is looking for a Senior Data Architect to join its team of analytics professionals to support its PA Longitudinal Data System (LDS) data integration services as well as system deployment and management efforts. The hire will be responsible for expanding and optimizing data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data architect who enjoys designing and building data systems from the ground up. The Data Architect will support our application developers, data engineers, data analysts, and data scientists on data initiatives and will ensure an optimal data delivery architecture that is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. They must also be comfortable with supporting data conversions associated with system modernization and/or replacement efforts. The right candidate will be excited by the prospect of building and optimizing the Commonwealth's longitudinal data architecture to support our next generation of data initiatives. Responsibilities: Translate business requirements into technical specifications, including data streams, integrations, transformations, databases, data lakes, data warehouses, and data products Define the data architecture framework, standards, and principles, including modeling, metadata, reference data, master data, and security for the PA LDS environment Define reference architecture, which is a pattern others can follow to create and improve data systems Define full life cycle of data process flows (data origins, organizational data flows and functions, how data flows are managed, and how data changes in transition) Create procedures to ensure data accuracy, quality, timeliness, availability, and accessibility Create and implement data management processes and procedures Collaborate with other teams within the organization to devise and implement data strategies, build models, and assess shareholder needs and goals Develop application programming interfaces (APIs) to retrieve data Define and deploy large, complex data environments that meet functional / non-functional business area requirements Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Design the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and 'big data' technologies Qualifications: Bachelor's Degree in Computer Science or related field of study and minimum 10 years of data/database background including 5 years acting as a Data Architect. Candidate must have 2-3 years of cloud based data services in AWS such as ECT, Glue, EMR, RDS, Redshift. Must have real-time data streaming experience with Storm, Spark-Streaming, Kafka or similar Strong data management skills to collect, store, and use data in an efficient and cost-effective manner Experience in system development life cycle, project management approaches, and requirements, design, and test techniques Experience in established and emerging data management and reporting technologies with knowledge of columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases Experience building and optimizing 'big data' data pipelines, architectures, and data sets. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement Strong project management and organizational skills Experience supporting and working with cross-functional teams in a dynamic environment. We are looking for a candidate with 5 years of experience in a Data Architect role, who has attained a degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. They should also have experience using the following software/tools: Experience with big data tools: Hadoop, Spark, Kafka, etc. Experience in artificial intelligence and machine learning (AI/ML) to build scalable systems for handling big data Experience using data modeling tools like ERWin or Visio to visualize metadata and database schemas and/or architectures Experience with relational SQL and NoSQL databases, including Oracle, MS SQL Server, Postgres, Cassandra, etc. Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. Experience with data integration services solutions from vendors such as Informatica, MuleSoft, Talend, TIBCO, etc. Experience with cloud-based data services such as AWS (EC2, Glue, EMR, RDS, Redshift, etc.) Experience with stream-processing systems: Storm, Spark-Streaming, Kafka etc. Experience with object-oriented/object function scripting languages: Python, R, Java, C++, Scala, etc. Required Skills : SEE REQUIREMENTS IN JOB DESCRIPTION AND FOLLOW. CANDIDATES WHO DON'T MEET THE EXPECTATIONS WILL BE FLAGGED AND SENT TO VENDOR MANAGEMENT. Basic Qualification : Additional Skills : Long Term Contract Background Check :Yes Drug Screen :Yes Notes : Selling points for candidate :Long Term Contract Project Verification Info :SOW/PO Exhibit A Apex Letter Candidate must be your W2 Employee :No Exclusive to Apex :No Face to face interview required :No Candidate must be local :No Candidate must be authorized to work without sponsorship ::No Interview times set :Yes Type of project :Development/Engineering Master Job Title :Architect: Data BI Branch Code :Philadelphia</p>

Data Architect Jobs in Harrisburg, PA

Lead Data Architect Oracle Health
November 20, 2024

Senior Data Architect Remote
November 7, 2024

Data Architect Life Sciences Sector Manager Consulting Location Open
November 5, 2024

Data Architect
October 31, 2024

Senior Data Architect Cloudaws
October 30, 2024

Senior Data Architect Cloudaws
October 29, 2024

Solution And Data Architect
October 28, 2024

Data Architect
October 25, 2024

Quick filters

Top companies

Data Architect Jobs in Harrisburg, PA

Lead Data Architect Oracle HealthNovember 20, 2024

Senior Data Architect RemoteNovember 7, 2024

Data Architect Life Sciences Sector Manager Consulting Location OpenNovember 5, 2024

Data ArchitectOctober 31, 2024

Senior Data Architect CloudawsOctober 30, 2024

Senior Data Architect CloudawsOctober 29, 2024

Solution And Data ArchitectOctober 28, 2024

Data ArchitectOctober 25, 2024