Principal Data Engineer-BI Developer
Company: Alameda Health System
Location: Oakland
Posted on: May 25, 2023
|
|
|
Job Description:
Summary
SUMMARY: Functions as a database leader, responsible for populating
the enterprise data warehouse so that Business Intelligence clients
(Data Scientists, Data Analysts etc.) are making efficient use of
the warehouse.
font-family:"Tahoma","sans-serif > DUTIES & ESSENTIAL JOB
FUNCTIONS: 9.0pt;line-height:115%;font-family:"Tahoma","sans-serif
> NOTE : The following are the duties performed by employees in
this classification. However, employees may perform other related
duties at an equivalent level. Not all duties listed are
necessarily performed by each individual in the classification.
"Tahoma","sans-serif > 1. Contributes to the short term and long
term data warehouse architecture.
"Tahoma","sans-serif > 2. Creates data environments and/or data
sets to serve a wide range of data users, including but not limited
to Data Scientists, Data Analysts, Business Analysts etc
"Tahoma","sans-serif > 3. Creates data warehouses, using best
practices to gather requirements, model data, and implement a
system that is highly performant and near-real-time.
"Tahoma","sans-serif > 4. Develops interactive reporting
solutions using SSRS / Power BI / etc.
"Tahoma","sans-serif > 5. Extends existing Data Warehouse
infrastructures and SSAS cubes with new dimensionality and new data
sources using SSIS, T-SQL, and SSAS
"Tahoma","sans-serif > 6. Improves data governance and data
quality using Master Data Management systems (MDS, DQS and
others)
"Tahoma","sans-serif > 7. Performs ETL work to pull data from
source systems (both on prem and hosted), including manipulating
data, and placing in the data warehouse environment.
mso-fareast-font-family:"Times New
Roman";mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA"> 8. Programs complex SQL queries
and stored procedures.
justify"> MINIMUM QUALIFICATIONS:
"Tahoma","sans-serif > Required Education: High School Diploma
or G.E.D.
"Tahoma","sans-serif > Preferred Education: Bachelor's of
Science degree in Information Management, Project Management,
Engineering or related field preferred.
"Tahoma","sans-serif > Required Experience: Five years technical
experience in a business intelligence position.
mso-fareast-font-family:"Times New
Roman";mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA"> Preferred Experience: Previous
experience as a Data Engineer / Database Administrator and/or
Business Intelligence Analyst.
Experience in Microsoft SQL, Microsoft BI Stack (SSIS, SSAS, SSRS)
and Microsoft Sharepoint; experience in developing Business
Intelligence solutions (ETL, cubes, reports, dashboards,
scorecards) using Microsoft SQL Server tools (SSIS, SSAS, SSRS) in
a data warehousing environment.
Information Systems
SYS BI Reporting
Full Time
Day
Business Professional & IT
FTE: 1
Keywords: Alameda Health System, Oakland , Principal Data Engineer-BI Developer, IT / Software / Systems , Oakland, California
|
Click
here to apply!
|
