332 Data Warehouse Architect jobs in the United States

• Bachelor's degree in related area and / or equivalent experience / training.
• Minimum 7 Years experience in a like role and institution
• Significant hands-on experience with Microsoft SQL Server and SSIS
• Significant hands-on experience with Tableau BI or other similar visualization applications
• Advanced skills associated with programming design, modification and implementation. In-depth knowledge of secure software development. Requires in-depth knowledge of applications programming technologies, development tools and protocols.
• In-depth knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs. Demonstrated ability to create software specifications.
• Demonstrated experience with database administration. Advanced knowledge of complex database management systems and standards. Knowledge relating to extremely highly complex database system design. Advanced database querying and modeling skills working with moderately complex databases. In-depth knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level.
• Familiarity with logical data design and data mapping or data conversion.
• Expert knowledge of test application code in client server environment.
• Ability to write technical documentation in a clear and concise manner.
• Familiarity with data quality and governance issues and requirements.
• Possesses advanced knowledge of professional IT concepts. Broad knowledge of the IT environment.
• Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digital forensics, including data collection, examination and analysis.
• In-depth knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Expert knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware.
• Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent / related functions. Experience in data integration and the specification of data services. Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.
• Technical skill to develop, implement and test disaster recovery functions using backup technologies.
• Demonstrated expert project management skills.
• Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner.
• Demonstrated ability to maintain a climate of fairness, cooperation. Demonstrated skill leading technical teams, including organizing workflow and scheduling assignments. Ability to work independently on complex technical projects as well as on a team of technical professionals and departmental decision-makers. Position requires frequent interface with senior level personnel on matters of significance.
• Ability to solve complex problems and perform work assignments requiring independent thought and judgment
• Knowledge of current industry practices, trends and resources (i.e., vendors, agencies, etc.)

IT EIA Health Quality

Full Time

85321BR

Job Summary

The Data Warehouse Architect in Enterprise Information & Analytics (EIA) designs the Scuba data warehouse ecosystem with a focus on ambulatory-related data. The role involves leading data warehouse operations, collaborating with stakeholders, providing technical direction, optimizing performance, driving innovation, and establishing data governance and standardization to align with business objectives.
* Architecture: Design both backend and frontend of the Scuba data warehouse ecosystem, including specialized data assets like DART, focusing on ambulatory-related data models and visualization solutions. Design and implement efficient and adaptable data models to support data exploration, data science, and analytics, resulting in insights that inform key business decisions.
* Operations: Lead data warehouse operations in collaboration with EIA colleagues. Design, develop, and optimize ETL workflows to support ambulatory business functions.
* Technical Leadership: Provide technical direction for analysts and developers in EIA, guiding them in creating trusted data assets and conducting code reviews. Serve as a subject matter expert in data warehouse concepts such as Kimball, star schema, snowflake schemas, and normalized and dimensional data models.
* Stakeholder Collaboration: Serve as a valued partner to stakeholders in the ambulatory business unit, offering data and analytics solutions while demonstrating a deep understanding of their business goals and operational objectives. Collaborate with departmental data stewards and technical system owners to establish a comprehensive understanding of the organization's processes and data, ensuring alignment with ambulatory business needs.
* Communication: Translate business requirements from the ambulatory unit into technical specifications, ensuring alignment with organizational goals and addressing business needs.
* Performance Monitoring and Optimization: Proactively monitor and analyze performance to identify and recommend optimizations, enhancing system performance.
* Innovation: Stay current with the latest trends in data and analytics technologies, and drive innovation for the Scuba data warehouse ecosystem.
* Governance and Standards: Play an active role in establishing data governance and standardization, ensuring new and existing data assets conform to UCSF standards with appropriate access controls.

The final salary and offer components are subject to additional approvals based on UC policy.

Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement.

The salary range for this position is $190,000 to $210,000 (Annual Rate).

To learn more about the benefits of working at UCSF, including total compensation, please visit:

Department Description

The mission of the Enterprise Information and Analytics (EIA) department is to advance UCSF's institutional priorities by enhancing access to and the use of data and analytics, including appropriate data platforms and data governance, in a manner that meets the unique needs across the education, research, and care mission areas. The department achieves its goals by working with clinical, research, education, and business partners to organize, integrate, govern, and transform UCSF's data assets into actionable insight and information.

Required Qualifications

• Bachelor's degree in related area and / or equivalent experience / training.
• Minimum 7 Years experience in a like role and institution
• Significant hands-on experience with Microsoft SQL Server and SSIS
• Significant hands-on experience with Tableau BI or other similar visualization applications
• Advanced skills associated with programming design, modification and implementation. In-depth knowledge of secure software development. Requires in-depth knowledge of applications programming technologies, development tools and protocols.
• In-depth knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs. Demonstrated ability to create software specifications.
• Demonstrated experience with database administration. Advanced knowledge of complex database management systems and standards. Knowledge relating to extremely highly complex database system design. Advanced database querying and modeling skills working with moderately complex databases. In-depth knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level.
• Familiarity with logical data design and data mapping or data conversion.
• Expert knowledge of test application code in client server environment.
• Ability to write technical documentation in a clear and concise manner.
• Familiarity with data quality and governance issues and requirements.
• Possesses advanced knowledge of professional IT concepts. Broad knowledge of the IT environment.
• Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digital forensics, including data collection, examination and analysis.
• In-depth knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Expert knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware.
• Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent / related functions. Experience in data integration and the specification of data services. Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.
• Technical skill to develop, implement and test disaster recovery functions using backup technologies.
• Demonstrated expert project management skills.
• Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner.
• Demonstrated ability to maintain a climate of fairness, cooperation. Demonstrated skill leading technical teams, including organizing workflow and scheduling assignments. Ability to work independently on complex technical projects as well as on a team of technical professionals and departmental decision-makers. Position requires frequent interface with senior level personnel on matters of significance.
• Ability to solve complex problems and perform work assignments requiring independent thought and judgment
• Knowledge of current industry practices, trends and resources (i.e., vendors, agencies, etc.)

Preferred Qualifications

• Clarity Data Model Certification

About UCSF

At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what's possible for the patients we serve - a promise we share with the professionals who make up our team.

Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report - UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence - also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity - both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available at diversity.ucsf.edu

Join us to find a rewarding career contributing to improving healthcare worldwide.

Equal Employment Opportunity

The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law.

Organization

Health

Job Code and Payroll Title

000600 DATA SYS ANL 5

Job Category

Clinical Systems / IT Professionals

Bargaining Unit

99 - Policy-Covered (No Bargaining Unit)

Employee Class

Career

Percentage

100%

Location

San Francisco, CA

Campus

Mission Center Building (SF)

Work Style

Flexible

Shift

Days

Shift Length

8 Hours

Additional Shift Details

Monday - Friday

Data Warehouse Architect IT EIA Health Quality Full Time 85321BR Job Summary The Data Warehouse Architect in Enterprise Information & Analytics (EIA) designs the Scuba data warehouse ecosystem with a focus on ambulatory-related data. The role involves leading data warehouse operations, collaborating with stakeholders, providing technical direction, optimizing performance, driving innovation, and establishing data governance and standardization to align with business objectives. * Architecture: Design both backend and frontend of the Scuba data warehouse ecosystem, including specialized data assets like DART, focusing on ambulatory-related data models and visualization solutions. Design and implement efficient and adaptable data models to support data exploration, data science, and analytics, resulting in insights that inform key business decisions. * Operations: Lead data warehouse operations in collaboration with EIA colleagues. Design, develop, and optimize ETL workflows to support ambulatory business functions. * Technical Leadership: Provide technical direction for analysts and developers in EIA, guiding them in creating trusted data assets and conducting code reviews. Serve as a subject matter expert in data warehouse concepts such as Kimball, star schema, snowflake schemas, and normalized and dimensional data models. * Stakeholder Collaboration: Serve as a valued partner to stakeholders in the ambulatory business unit, offering data and analytics solutions while demonstrating a deep understanding of their business goals and operational objectives. Collaborate with departmental data stewards and technical system owners to establish a comprehensive understanding of the organization's processes and data, ensuring alignment with ambulatory business needs. * Communication: Translate business requirements from the ambulatory unit into technical specifications, ensuring alignment with organizational goals and addressing business needs. * Performance Monitoring and Optimization: Proactively monitor and analyze performance to identify and recommend optimizations, enhancing system performance. * Innovation: Stay current with the latest trends in data and analytics technologies, and drive innovation for the Scuba data warehouse ecosystem. * Governance and Standards: Play an active role in establishing data governance and standardization, ensuring new and existing data assets conform to UCSF standards with appropriate access controls. The final salary and offer components are subject to additional approvals based on UC policy. Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement. The salary range for this position is $129,600 - $303,800 (Annual Rate). To learn more about the benefits of working at UCSF, including total compensation, please visit: Department Description The mission of the Enterprise Information and Analytics (EIA) department is to advance UCSF's institutional priorities by enhancing access to and the use of data and analytics, including appropriate data platforms and data governance, in a manner that meets the unique needs across the education, research, and care mission areas. The department achieves its goals by working with clinical, research, education, and business partners to organize, integrate, govern, and transform UCSF's data assets into actionable insight and information. Required Qualifications Bachelor's degree in related area and/or equivalent experience/training. Possesses advanced knowledge of professional IT concepts. Broad knowledge of the IT environment. Advanced skills associated with programming design, modification and implementation. In-depth knowledge of secure software development. Requires in-depth knowledge of applications programming technologies, development tools and protocols. Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digital forensics, including data collection, examination and analysis. In-depth knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs. Demonstrated ability to create software specifications. Demonstrated experience with database administration. Advanced knowledge of complex database management systems and standards. Knowledge relating to extremely highly complex database system design. Advanced database querying and modeling skills working with moderately complex databases. In-depth knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level. Familiarity with logical data design and data mapping or data conversion. In-depth knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Expert knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware. Expert knowledge of test application code in client server environment. Ability to write technical documentation in a clear and concise manner. Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent / related functions. Experience in data integration and the specification of data services. Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes. Familiarity with data quality and governance issues and requirements. Technical skill to develop, implement and test disaster recovery functions using backup technologies. Demonstrated expert project management skills. Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner. Demonstrated ability to maintain a climate of fairness, cooperation. Demonstrated skill leading technical teams, including organizing workflow and scheduling assignments. Ability to work independently on complex technical projects as well as on a team of technical professionals and departmental decision-makers. Position requires frequent interface with senior level personnel on matters of significance. Significant hands-on experience with Microsoft SQL Server and SSIS Significant hands-on experience with Tableau BI or other similar visualization applications Ability to solve complex problems and perform work assignments requiring independent thought and judgment Knowledge of current industry practices, trends and resources (i.e., vendors, agencies, etc.) Preferred Qualifications Clarity Data Model Certification About UCSF At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what's possible for the patients we serve - a promise we share with the professionals who make up our team. Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report - UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents. Pride Values UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence - also known as our PRIDE values. In addition to our PRIDE values, UCSF is committed to equity - both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available at diversity.ucsf.edu Join us to find a rewarding career contributing to improving healthcare worldwide. The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law. Organization Health Job Code and Payroll Title 000600 DATA SYS ANL 5 Job Category Clinical Systems / IT Professionals Bargaining Unit 99 - Policy-Covered (No Bargaining Unit) Helping all candidates find great careers is our goal. The information you provide here is secure and confidential. We are now directing you to the original job posting. Please apply directly for this job at the employer’s website. #J-18808-Ljbffr

THE OVERALL PURPOSE OF POSITION:

• The Data warehouse Architect will spearhead the design and development of a new, high performance enterprise data warehouse for the organization, using industry best practices and data modeling techniques.

SCOPE OF WORK

• The position’s SCOPE OF WORK include the following:

• Collaborate with important stakeholders, including division-based data stewards as well as technical system owners to establish an understanding of the organization’s vast processes and data.

• Design and implement an efficient and adaptable data model to support data exploration, data science, analytics, and GIS, resulting in insights to inform key business decisions.

• Actively participate in process improvement initiatives and in setting best practice standards around Data Architecture, Metadata, Governance, Master Data Management, and Data Quality flows.

• Proactively investigate opportunities to increase the value of the data to the business while focusing on projects that improve business processes.

• Designs, builds and maintains flexible and scalable data warehouse solutions to support Business Intelligence (BI) and Reporting projects.

• Provides expertise in the creation and refinement of agile technical stories for data architecture and development.

• Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon, star schema, snowflake schemas, and normalized and de-normalized data models).

• Helps to develop, implement, and maintain appropriate data governance on the data warehouse and associated metadata for purposes of data quality, integrity, availability, and security.

• Proactively monitors and analyzes performance to identify and recommend optimizations.

• Coordinates with team members and leads the implementation of Master Data Management, in conjunction with the new data warehouse.

• Leads the integration of the data warehouse with a modern, leading business intelligence platform.

QUALIFICATION AND EXPERIENCE:

• Bachelor’s degree (master’s degree preferred) and relevant technical training and relevant technical training and certifications.

• Five (5) to Seven (7) years of directly related experience.

• One (1) to Two (2) years of business leadership experience.

• Five (5) or more years of recent Data Warehouse Architecture experience to build and articulate conceptual, logical and physical dimensional data models and third normal form artifacts.

• Five (5) or more years of experience with business intelligence technologies and solutions.

• Five (5) or more years of experience leading teams on IT initiatives, particularly those related to big data.

• Two (2) or more years of experience with leading data quality tools.

CORE COMPETENCIES

• Forward Thinking: The ability to anticipate the implications and consequences of situations and take appropriate action to be prepared for possible contingencies.

• Thinks Critically: The ability to approach one’s work analytically by identifying issues/questions, gathering and evaluating data, and creating evidence-based recommendations or solutions.

• Embrace Innovation & Change: The ability to respond positively to change and demonstrate flexibility, and openness to new ways of thinking and doing things.

• Communicate Openly & Effectively: The ability to effectively communicate in multiple modes and in a way that fosters understanding and dialogue, as well as engages with others in a way that demonstrates emotional intelligence.

• Performance Focused: The ability to take ownership for one’s own or one’s employees’ performance, by setting clear goals and expectations, tracking progress against the goals, providing feedback, and addressing performance problems and issues promptly.

• Apply Customer Lens: The ability to provide the best service to customers (internal and external) with the goal of exceeding their expectations while maintaining integrity.

• Develop Self & Others: The ability to identify, learn, and apply new skills or habits as needed to perform successfully on the job.

• Foster Collaboration: The ability to look beyond immediate teams, broaden peer networks, and finding ways to partner with internal and external stakeholders to achieve success.

DHHS is the agency recognized by the Department of Health and Human Services (DHHS), Administration for Children and Families (ACF) as responsible for administering federal Child Welfare programs under Titles IV-B and IV-E of the Social Security Act. The DHHS mission includes a commitment to ensuring that children and youth served by the public systems are safe; to promote, improve and sustain a higher quality of life while enhancing their wellbeing; and to have permanent and stable family lives.

This position is assigned to support Child Welfare Data Warehouse team in developing Federal reporting, ad-hoc, ETL, and Business Objects reports that are critical to the success of the application such as NYTD, AFCARS, and NCANDS.  Also, any other projects that need ETL support that add value to the Department and end users to get them the data they need for them to be more productive.

Tasks:

·    The Data Warehouse Architect will work with State and contract staff and the operational SACWIS/CCWIS system developers to ensure that the operational system database will support the data needs of the Child Welfare Data Warehouse, and the functionality needed to extract the needed data on a regular basis.

•    Work with State and contract staff to design and load the Child Welfare Data Warehouse database model to support the reporting and analytic needs of DHHS.

•    As the operational SACWIS/CCWIS project continues, work with State, contract, and the operational SACWIS/CCWIS contractor staff to make needed changes to the Child Welfare data warehouse that may evolve from the operational SACWIS/CCWIS system.

•    Work closely with State and contract staff to ensure that they are fully aware of the decisions and impacts involved in the supporting and/or enhancing the DHHS Data Warehouse models and can support and extend them by the end of the contract. 

•    Child Welfare Data Warehouse Architects perform application development tasks in support of building business intelligence applications and integrating data warehouse resources into other DHHS applications. In addition, they provide database expertise to other application developers in close collaboration with DBAs and other data management staff.

•    Creating data warehouse-based applications including reporting, dashboards and other information analysis, visualizations and delivery systems.

•    Extract, transform, and load systems to move data from the various operational systems in which it is collected to a cleansed, consolidated data warehouse.

•    Work with data warehouse Federal reporting team members and end user query developers to design and improve database queries.

•    Data warehouse Architects are also expected to be able to work with agency requestors to define and develop new queries and provide training and technical support to both DTMB developers and end user query developers.

•    Working with end user requestors to understand their data needs and create and implement solutions to those needs.

•    Develop and present training classes for DTMB developers to better understand how to use the Teradata and BI development tools to create and implement reporting solution using the data warehouse.

•    Provide one on one support for developers and end users to assist them in accomplishing their federal data reporting needs.

SOM Enterprise Data Warehouse Environment

•    Teradata Cloud version 17.20

•    Shared platform with other State of Michigan departments

•    Business Objects XI 4.2 SP4 on a Windows 2012 virtual platform.

Join to apply for the Data Warehouse Architect role at UCSF Health

Continue with Google Continue with Google

3 days ago Be among the first 25 applicants

Join to apply for the Data Warehouse Architect role at UCSF Health

Get AI-powered advice on this job and more exclusive features.

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Job Summary

The Data Warehouse Architect in Enterprise Information & Analytics (EIA) designs the Scuba data warehouse ecosystem with a focus on ambulatory-related data. The role involves leading data warehouse operations, collaborating with stakeholders, providing technical direction, optimizing performance, driving innovation, and establishing data governance and standardization to align with business objectives.

• Architecture: Design both backend and frontend of the Scuba data warehouse ecosystem, including specialized data assets like DART, focusing on ambulatory-related data models and visualization solutions. Design and implement efficient and adaptable data models to support data exploration, data science, and analytics, resulting in insights that inform key business decisions.
• Operations: Lead data warehouse operations in collaboration with EIA colleagues. Design, develop, and optimize ETL workflows to support ambulatory business functions.
• Technical Leadership: Provide technical direction for analysts and developers in EIA, guiding them in creating trusted data assets and conducting code reviews. Serve as a subject matter expert in data warehouse concepts such as Kimball, star schema, snowflake schemas, and normalized and dimensional data models.
• Stakeholder Collaboration: Serve as a valued partner to stakeholders in the ambulatory business unit, offering data and analytics solutions while demonstrating a deep understanding of their business goals and operational objectives. Collaborate with departmental data stewards and technical system owners to establish a comprehensive understanding of the organization’s processes and data, ensuring alignment with ambulatory business needs.
• Communication: Translate business requirements from the ambulatory unit into technical specifications, ensuring alignment with organizational goals and addressing business needs.
• Performance Monitoring and Optimization: Proactively monitor and analyze performance to identify and recommend optimizations, enhancing system performance.
• Innovation: Stay current with the latest trends in data and analytics technologies, and drive innovation for the Scuba data warehouse ecosystem.
• Governance and Standards: Play an active role in establishing data governance and standardization, ensuring new and existing data assets conform to UCSF standards with appropriate access controls.
  
  

• Architecture: Design both backend and frontend of the Scuba data warehouse ecosystem, including specialized data assets like DART, focusing on ambulatory-related data models and visualization solutions. Design and implement efficient and adaptable data models to support data exploration, data science, and analytics, resulting in insights that inform key business decisions.
• Operations: Lead data warehouse operations in collaboration with EIA colleagues. Design, develop, and optimize ETL workflows to support ambulatory business functions.
• Technical Leadership: Provide technical direction for analysts and developers in EIA, guiding them in creating trusted data assets and conducting code reviews. Serve as a subject matter expert in data warehouse concepts such as Kimball, star schema, snowflake schemas, and normalized and dimensional data models.
• Stakeholder Collaboration: Serve as a valued partner to stakeholders in the ambulatory business unit, offering data and analytics solutions while demonstrating a deep understanding of their business goals and operational objectives. Collaborate with departmental data stewards and technical system owners to establish a comprehensive understanding of the organization’s processes and data, ensuring alignment with ambulatory business needs.
• Communication: Translate business requirements from the ambulatory unit into technical specifications, ensuring alignment with organizational goals and addressing business needs.
• Performance Monitoring and Optimization: Proactively monitor and analyze performance to identify and recommend optimizations, enhancing system performance.
• Innovation: Stay current with the latest trends in data and analytics technologies, and drive innovation for the Scuba data warehouse ecosystem.
• Governance and Standards: Play an active role in establishing data governance and standardization, ensuring new and existing data assets conform to UCSF standards with appropriate access controls.
  
  

• Bachelor's degree in related area and/or equivalent experience/training.
• Possesses advanced knowledge of professional IT concepts. Broad knowledge of the IT environment.
• Advanced skills associated with programming design, modification and implementation. In-depth knowledge of secure software development. Requires in-depth knowledge of applications programming technologies, development tools and protocols.
• Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digital forensics, including data collection, examination and analysis.
• In-depth knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs. Demonstrated ability to create software specifications.
• Demonstrated experience with database administration. Advanced knowledge of complex database management systems and standards. Knowledge relating to extremely highly complex database system design. Advanced database querying and modeling skills working with moderately complex databases. In-depth knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level.
• Familiarity with logical data design and data mapping or data conversion.
• In-depth knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Expert knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware.
• Expert knowledge of test application code in client server environment.
• Ability to write technical documentation in a clear and concise manner.
• Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent / related functions. Experience in data integration and the specification of data services. Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.
• Familiarity with data quality and governance issues and requirements.
• Technical skill to develop, implement and test disaster recovery functions using backup technologies.
• Demonstrated expert project management s

Get AI-powered advice on this job and more exclusive features.

We are IntelliShift, a rapidly growing B2B SaaS company with more than 20 years of expertise in fleet management technology. IntelliShift is the fleet intelligence platform for safety and operations teams, and we empower construction, utilities, field services, and last mile delivery businesses to make the intelligent shift from siloed data using point solutions, to one simple, powerful platform. We provide these customers with a level of insight they've never had before to improve safety, establish next generation operational efficiency, and make intelligent decisions.

We are looking for an experienced Data Warehouse Architect/Engineer to join our software development team. We are focused on enabling our customers to make data-driven decisions that deliver value to their shareholders and looking for someone with proven proficiency in architecting, designing and development experience with batch and real time streaming infrastructure and workloads.

What you will do:

• Help design, build, and maintain a multi-terabyte data warehouse in support of Data and Analytics and Data Product use cases
• Implementing scalable, high-performance data pipelines for data ingestion, storage. processing and transformation to support analytics and ML pipelines
• Develop standards for database design and implementation of various strategic data architecture initiatives around data quality, data management policies/standards, data governance, privacy and metadata management
• Design, development, monitoring, and management of ELT/ETL pipelines and procedures
• Design and development of reports, stored procedures and functions
• Stay on top of new technology developments in data warehousing, big data processing, and other relevant fields
• Participate in project planning, estimation and status activities
• Research and resolve support tickets and escalations
  
  
  

• Bachelor's degree in computer science or related field
• Experience and working knowledge of streaming platforms, typically based around Kafka
• Strong grasp of Azure & AWS data platform services and their strengths/weaknesses
• 3+ years' experience of Snowflake Data Warehouse or similar technology
• 5+ years and Intermediate to Advanced knowledge of SQL
• 5+ years and Intermediate to Advanced stored procedure/function development
• 5+ years and Intermediate to advanced stored procedure/function development
• Solid understanding of data warehousing concepts and architecture
• Experience developing data warehouse reports and analytic queries
• 2+ years' experience in SSRS or similar reporting tool
• Ability to research data issues and resolve them in a timely manner
  
  
  

• Data replication concepts
• Experience developing ETL/ETL using stored procedures
• Experience with JavaScript development
• Machine Learning experience
  
  
  

• Customer-Obsessed- Our customers are at the center of everything we do. When they win, we win. We're more than just a vendor; we're committed partners
• No-Box Innovation- Forget thinking outside the box—what box? We embrace bold ideas and build what hasn't been built before to drive our customers and ourselves forward
• Growth Through Friction- Not all friction is bad. We challenge inefficiencies, drive innovation, push for a stronger business, and break through limits
• Trust Through Action- Promises don't build trust—actions do. We lead with transparency, act with integrity, and stay committed to always doing right by those we work with
• Own It- Every action matters, so make it count. We are accountable for our work, own our outcomes, and always strive to make a positive difference
  
  
  

• Seniority level Associate

• Employment type Full-time

• Job function Information Technology
• Industries IT Services and IT Consulting

Referrals increase your chances of interviewing at IntelliShift by 2x

Get notified about new Data Warehouse Architect jobs in Commack, NY .

Stamford, CT 130,000.00- 220,000.00 1 day ago

Stamford, CT 150,000.00- 200,000.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.