Insight Global is seeking a Senior Data Engineer/Architect to join our clients growing medical center. This person will be responsible for designing, developing, testing, documenting and maintaining data warehouse and analytics architecture to meet UCSF's data and analytics needs!

Day to Day Responsibilities:

* Collaborate with business and technology partners to gather business requirements and create architectural designs spanning UCSF missions: Education, Research, Health, and Financial and Administrative Services

* Use business domain knowledge to profile data and determine the best approaches to extract data into data warehouses.

* Design data models and ETLs to in the Education Data Warehouse for all UCSF Schools and Programs.

* Apply the Kimball dimensional data modeling technique to build and enhance the enterprise data warehouse; this ties to the need for enterprise design intention, connecting Education to other UCSF mission assets.

* Design, develop, test, document, and support new and existing ETL processes using Microsoft SQL Server Integration Services (SSIS), AWS Glue, Azure Data Factory, IBM InfoSphere DataStage, or other tools.

* Write ETL specifications for more junior data engineers to execute.

* Demonstrate fluency in SQL programming and performance tuning.

* Develop business intelligence products, such as reports and dashboards, using Tableau or other data visualization tools.

* Document business rules and metadata in the data dictionary and keep the information updated.

* Possess excellent communication skills and the ability to articulate system designs and patterns to varying levels of leadership.

* Participate in project planning, including scoping backlogs and determining estimates.

* Assume on-call duties to support the operation of reporting and analytics systems.

* Maintain appropriate business domain knowledge in healthcare, education, research, finance, and business administration.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

Must Haves:

* Proficient in ETL design and development -- experience with creating, coding and testing ETL routines (minimum 5 years using at least one ETL took such as Microsoft SSIS, Microsoft Azure Data Factory, AWS Glue etc)

* 5+ years exp designing reports, scorecards, and dashboards using Tableau, Power BI, or any data visualization tools.

* Must be able to work with multiple RDBMS environments (relational database management systems) such as Oracle, SQL Server, MySQL etc.

* Experience in enterprise data warehousing development, with a focus on cross-domain design in an academic setting

* At least 5 years of writing T-SQL. Experienced in writing complex SQL queries and stored procedures. Understanding of query performance tuning.

Nice to Have Skills & Experience

* Bachelors degree in a related area and / or equivalent experience

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.