SSIS T SQL Power BI Python Specialist (Jobs in Raleigh, NC)   Requirement id 135501 Job title Specialist Job location in Raleigh, NC Skills required Data Warehouse Development, Dimensional Modeling, ETL Development, SSIS T SQL Power BI Python Open Date 02-Aug-2022 Close Date Job type Contract Duration 5 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: Data Warehouse Development, Dimensional Modeling, ETL Development, SSIS T SQL Power BI Python Start date :09/05/2022 End Date :01/31/2023 Submission deadline :08/08/2022 Client Info :CoR-IT Description : PLEASE NOTE: This position is hybrid and requires 3 days per week onsite in Raleigh, NC at the start of the engagement. This requirement is non-negotiable. This position will support efforts in data engineering, business intelligence, and data analytics and reporting across the varied business departments at the City. This position will provide providing senior level data analysis and development of solutions that transform data into actionable and consumable information. This individual will work as part of a team to develop data pipelines, intermediate and final dimensional models, and SSAS/Power BI datasets as part of the Citys Enterprise Data Warehouse solution. The business intelligence platform includes Microsoft SQL Server, SSIS, SSAS, Power BI Premium, and CData Sync. Data sources include a variety of sources and applications including PeopleSoft, CityWorks, SAP SuccessFactors, and other applications leveraging MS SQL Server, Oracle, or SaaS-based delivery. Essential Duties and Responsibilities (not intended to be all inclusive): • Design, build and deploy dimensional models and ETL pipelines • Design, build and deploy curated Power BI datasets from dimension models or SSAS tabular models • Collect, organize, analyze and disseminate large data sets with attention to detail and accuracy. • Contribute knowledge and documentation to growing our data analysis community in the City. • Collaborate with members of the business, project teams and IT staff as needed to fulfill the responsibilities described above. • All other job-related duties as it relates to the job function or as delegated by the management team. Knowledge: • Enterprise Data Warehousing and dimensional modeling best practices • Data transformation processes and ETL tools, including SSIS and scripted pipelines with Python, SQL, and/or PowerShell • Data security best practices and regulatory compliance standards (PCI DDS, HIPPA, CJIS, FISMA) is a plus • Broad knowledge of business intelligence, analytics, dashboards and reporting tools used to process structured and unstructured data. • Ability to translate business needs into technical specifications to design, build and deploy business analysis solutions. Skills: • Expert knowledge with T-SQL and dimensional modeling • Experienced in ETL development. Experience with Python is a plus • Experience working in a Data Warehousing environment • Experience with Git and other tools for version control and development/deployment automation • Active listening and critical thinking. • Ability to communicate and work with business subject matter experts and organizational leadership. • Ability to communicate technical information well, both written and oral, and make effective public presentations.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 135501 while calling.   Other jobs in NC: Chapel Hill (2), Charlotte (58), Dix Campus (1), Greensboro (3), Morrisville (2), North Charlotte (2), Raleigh (96), St Raleigh (2), Winston Salem (3),    Data Warehouse Development job openings in other states Jobs List Data Warehouse Developer II - WISCJP00016466 Create date: 24-Jan-2020 Start Date : 2/17/2020 End Date : Submission Dead Line : 8:00 a.m. CT on Wednesday, January 29th, 2020 Client Info : DCF – Department of Children and Families Description : Note: Comments: 1)An in-person interview will be required before a final hire is mad.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) Business Intelligence Data Warehouse Developer II Create date: 15-Aug-2019 Start Date : 09/16/2019 Submission Dead Line : 8/21/2019 Description : The College is seeking one (1) highly motivated and capable person to help with the effort to convert existing ETLs to SQL Server Integration Services (SSIS). Requirements include performing data analysis, solution development in the form o.... (This job is for - SSIS ETL Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer II Consultant Create date: 16-May-2019 Start Date :06/17/2019 Submission Deadline :3:00 PM, Friday, May 24, 2019. Note : Preference- local candidates. Description : It is seeking one (1) highly motivated and capable person to help with the effort to convert existing ETLs to SQL Server Integration Services (SSIS). Requirements includ.... (This job is for - ETL Jobs in WI Madison Consultant - (in Madison, WI)) CSR 24 - Microsoft SQL Server Data Warehouse Developers -SPO Create date: 28-Feb-2019 Note: Email Submission Note: Only Submit TWO consultant candidate per company. Conference Call: 3/4/2019 @ 11:30 AM PST Submission Deadline: 3/15/2019 4:00 PM PST Start Date: 4/29/2019 End Date: 10/28/2020 Client: Health Information Technology(HIT) Description: The HIT Business .... (This job is for - job Jobs in CA RedwoodCity Developer - (in Redwood City, CA)) PL/SQL Developer - 40908 Create date: 30-Nov-2018 Job Description : The Role This position is responsible for developing, testing, analyzing, and maintaining database / software applications in support of the achievement of business requirements. The candidate will work with a project team to address a variety of business needs. The candidate may also assist with application .... (This job is for - job Jobs in AL Birmingham Developer - (in Birmingham, AL))     (Specialist: Data Warehouse Development, Dimensional Modeling, ETL Development, SSIS T SQL Power BI Python in Raleigh, NC)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)