SQL Queries SSRS 2005 Or Greater PowerBI Analyst (Jobs in Olympia, WA)   Requirement id 107409 Job title Analyst Job location in Olympia, WA Skills required Data Warehouse Environment, Azure Environment, ETL Architecture, SQL Queries SSRS 2005 Or Greater PowerBI Open Date 11-Jun-2020 Close Date Job type Not specified Duration 6 Months Compensation DOE Status requirement --- Job interview type Phone Screening    Email Recruiter: coolsoft Job Description Analyst: Data Warehouse Environment, Azure Environment, ETL Architecture, SQL Queries SSRS 2005 Or Greater PowerBI Note: Email Submission Submission Deadline: 6/17/2020 5:00 PM PST Start Date: 7/1/2020 End Date: 12/31/2020 Client: Description: PROJECT DESCRIPTION AND REQUIREMENTS WAHBE requires an expert-level resource to be a valued contributor designing, developing, and releasing new and innovative Data Warehouse. This resource will work with new Azure technologies and platforms. Resource will perform all development activities within the defined parameters adhering to DW Architecture guidelines. A. PURPOSE AND GOALS • This resource will be a team member of the Data Warehouse team developing and providing development/production support in addition to enhancing existing data assets and ETL processes. • Once this project has been completed, WAHBE will have an operational Data Warehouse PROJECT-SPECIFIC QUALIFICATIONS AND EXPERIENCE List experience, qualifications, credentials, certifications, etc. that are specific to the project. • Required o Knowledge of Azure Data Warehouse environment (data factory, data blob, etc.) o Experience in Data Warehousing, ETL Architecture o Expert level code management and deployment o Moderate level data knowledge and analysis, inclined to learn Quickly o Experience with data platforms such as Oracle, SQL o Experience with one or more data and reporting tools such as SSRS, PowerBi o Exposure to Cloud technologies (e.g. Azure) o Able to communicate with clarity and precision DUTIES, TASKS, AND RESPONSIBILITIES • Develop DW ETL script using SQL to load data to data marts. Extensive use of trigger, store procedures and functions • Cleanse the source data, extract and transform data with business rules from Oracle • Fix invalid mappings, performance tuning, testing of Store procedure, functions and the target data • Involve in database design, planning, implementation of entity relationship modeling and dimensional modeling using Star and Snowflake schemas • Tuning Mappings and sessions for better performance and debugging of existing ETL processes • Work with server and network team on designing and implanting data system architect • Identify opportunities for process optimization, process redesign and development of new process • Work with DW team to create ETL CDC (Capture Data Change) mechanism • Develop metrics and reporting that help provide data for critical decision making • Ability to work with large amounts of data and find conclusions with attention to detail • Interpret data, analyze results using statistical techniques and provide ad-hoc/ongoing reports and dashboards • Analyze complex data and extract valuable insights in a compelling summarized view to present to management • Prepare ad-hoc management reports, research and analysis • Develop and implement databases, data collecting systems, data analytics and other strategies that optimize statistical efficiency and quality • Acquire data from primary or secondary data sources and maintain databases/data systems • Identify, analyze and interpret trends or patterns in complex data sets • Using a strong understanding of database methodology, data analysis, advanced SQL queries, ETL and business intelligence applications, the analyst will design query, develop reports using SSRS or PowerBI based on business requirements and deliverables for management • Model data using SQL and/or other data warehouse analytical tools • Responsible for all DW applications and scheduled jobs to ensure they are all successfully executed • Assist with data collection, analysis, and summarization   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 107409 while calling.   Other jobs in WA: Bellevue (2), Olympia (8), Seattle (18),    Data Warehouse Environment job openings in other states Jobs List Sr Database Architect - 57885 Create date: 10-Mar-2021 On-site/Remote: On-site Job industry: Public Sector and Government Description: Responsibilities Our Client in Columbus, Ohio is seeking an experienced Senior Database Architect for a contract role CANDIDATES MUST BE LOCAL TO CENTRAL OHIO FOR CONSIDERATION - remote start from .... (This job is for - job Jobs in OH Columbus Architect - (in Columbus, OH)) ITS63 EHS DW Developer 001-HIX_MHDW-Bfvp -Re-Post -SP Create date: 26-Feb-2021 Note: RTR form must be submitted Note: Email Submission Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 3/15/2021 Start Date: 3/25/2021 End Date: 6/30/2021 Client: EHS Description: The MassHealth Data Warehouse Team (MHDW) supports MassHealth organizati.... (This job is for - job Jobs in MA Quincy Developer - (in Quincy, MA)) ITS63 EHS FY21 Business Analyst 002-OPS-DWbfng -SP Create date: 01-Oct-2020 Note: Email Submission Note: RTR form must be submitted Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 10/8/2020 Start Date: 10/19/2020 End Date: 6/30/2021 Client: EHS Description: The Business Analyst, will be responsible for working with internal and extern.... (This job is for - job Jobs in MA Quincy Analyst - (in Quincy, MA)) Data Analyst - 63665 Create date: 29-May-2020 Candidate must be our W2 Employee Candidates RTR form should be only on the name of APEX Systems Description: MUST have previous Charter Communications experience and have a good reference. Please make sure to send over previous Charter managers information so we can check references on the front end. Cha.... (This job is for - job Jobs in NC Charlotte Analyst - (in Charlotte, NC)) Data Warehouse Solution Architect - NTTJP00013966 Create date: 28-Jan-2019 Start Date:2/11/2019 End Date:04/30/2020 Submission Deadline :02/11/2019 Note: Remote work accepted for this role. Description : we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presenc.... (This job is for - job Jobs in NC Trinity Architect - (in Trinity, NC))     (Analyst: Data Warehouse Environment, Azure Environment, ETL Architecture, SQL Queries SSRS 2005 Or Greater PowerBI in Olympia, WA)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)