Senior Data Warehouse Analyst Programmer
Job Field: Office Jobs
Location: BELLEVUE, WA
Salary: $-
Job Type: Part Time
JOB SUMMARY:
</tr>
</table>
<table border="0" bgColor="#F5F5F5" cellpadding="5" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>
<td align="left"><font style="font-size: 100%;">Title: Senior Data Warehouse Analyst Programmer<BR>Location: US-WA-Bellevue<BR>Other Locations:<BR>Job Summary<BR><BR><BR>Performs day-to-day enterprise data warehouse functions, including complex data analysis. Partners with Business stakeholders, partners and vendors to fulfill work/project requests, and help to expand the ETL/BI platform and back-office reporting functions. Develops and maintains DWH processes and tools. Provides business-critical transactional and financial information to internal customers (business owners/planners, executives, finance, etc.) as well as to external suppliers and partners.<BR><BR>Job Responsibilities<BR>* <BR>Designs, develops and maintains ETL processes to incorporate source data and make platform enhancements to the Enterprise Data Warehouse. Administers nightly ETL job stream, including some off hours support as needed. Designs, builds, maintains, and enhances the data mart and reporting features. Assists and/or is responsible for current and upcoming DW and BI platform/tool/technology migrations.<BR>* Performs complex data analysis and investigates data related issues within the Data Warehouse environment as well as source systems, implementing and optimizing ETL processes.<BR>* Participates in and contributes to all required steps of the SDLC process, including but not limited to documentation, testing and implementation.<BR>* Ensures all code is stored in the appropriate source control system. Ensures code follows best practices and standards as laid out by the Data Warehouse policies.<BR>* Ensures all maintenance, system integrity, capacity, scalability, and space requirements for the data warehouse environments are met. Monitors performance tuning of production DW database systems. Proactively identifies issues that compromise stored data. <BR>* Collaborates with the Business Intelligence/Web Analytics team to ensure business reporting and analytics requirements are supported by the Data Warehouse. Works closely with cross-function support team to keep DW running smoothly.<BR>* Assesses and implements production system changes to Data warehouse ETLs to ensure consistent and accurate reporting. <BR>* Maintains currency in profession, including attendance at training opportunities as well as conducting self-lead training over relevant topics.<BR>* Mentor team members on ETL best practices as well as design.<BR><BR>* Bachelor?s Degree and at least 5 years of DWH programming experience OR Master?s Degree and at least 3 years of DWH/ETL experience OR a High School Diploma / GED and at least 8 years of ETL experience<BR>* Experience working with Data Warehouse Concepts <BR>* Experience working with data, master data and metadata related standards, processes and technology<BR>* Experience designing business intelligence solutions<BR>* Experience defining, designing and implementing logical and physical data models<BR>* Experience in SQL and query tuning<BR>* Experience with data warehouse technologies and/or back-end reporting systems <BR>* Experience designing and developing da </font></td>
</tr>
</table>
<table border="0" bgColor="#F5F5F5" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>