AlpharettaRecruiter Since 2001
the smart solution for Alpharetta jobs

EDW Technical Lead

Company: EY
Location: Alpharetta
Posted on: April 3, 2021

Job Description:

Job Summary: The Information Management Technology organization is responsible for the end-to-end delivery of programs to develop and maintain Ernst & Young's global business intelligence, EDW and MDM platforms. The team is geographically dispersed and comprises of all disciplines required to deliver IT solutions for our customers, including project managers, business analysts, software engineers, quality assurance & testers and implementation managers. In addition the function works closely with the Enterprise & Solution Architecture and Infrastructure & Operations teams. The Enterprise Data Warehouse Technical Lead will be primarily responsible for implementing ETL processes using SSIS, to populate Kimball style star schemas using a variety of source data into the enterprise data warehouse, Microsoft PDW appliance and or Azure Data Factory. The candidate will have a deep understanding of both OLTP and star schemas, with all associated ETL constructs to effectively manage facts and dimensions. The resulting ETL processes should be scalable, efficient, audited and as re-usable as possible. This role should also be able to assess data quality and auditability of the overall flow. Within EDW domain, the Technical Lead will work with the EDW Business / Data Analyst to understand requirements, but also requires additional mastery of Business Intelligence concepts that support analytics, KPIs, metrics, dimensions, attributes and business processes (including but not limited to, those that ultimately are delivered as reports and data interfaces). Proficiency in the implementation of additional complex calculations and Big Data type of challenges is a must. The EDW Technical Lead must have significant experience in stakeholder relationship management skills to successfully manage the customer and stakeholders. Essential Functions of the Job: --- Develop, design, tune and maintain SSIS packages to perform the ETL process.--- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.--- Perform data profiling and source to target mappings (while capturing ETL and business metadata) for populating Kimball style dimensional models.--- Write scripts for automated testing of data in the target facts and dimensions.--- Capture audit information during all phases of the ETL process.--- Write and maintain documentation of the ETL processes via process flow diagrams.--- Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.--- Be able to implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables.--- Collaborate with business users, EDW team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse. Knowledge and Skill Requirements: -- Dimensional modeling experience preferably with a modeling tool such as Erwin in order to interact effectively with the Data Architect/Engineer -- ETL using tools such as SSIS or other and highly skilled in SQL development -- Other development complementary tools are a plus (C++ -- Strong communication skills -- IT background with experience across the systems development life cycle with experience in all project phases - plan, initiate, elaborate, design,build, test, implement -- Strong team working skills across matrixed client, supplier and geographically dispersed virtual teams -- Strong communication and interpersonal skills (includes negotiation) Supervision Responsibilities: -- Expected to act independently to deliver appropriate program/project requirements to schedule, budget and scope -- Leads one or more team members consisting of cross functional, global, and virtual groups; may need to supervise staff and assign responsibility to other team members; monitors progress as per documented scope -- Coaches, mentors and supports less experienced developers Additional Requirements: Education: -- A degree in Computer Science or a related discipline; or equivalent work experience Experience: -- 3-5 years of experience with Big Data, data warehousing and business intelligence projects. -- 5-10 years of experience with relational databases (SQL Server, PDW will be a plus). -- 3-5 years of experience with SSIS or other similar ETL tool -- Work experience in a professional services industry, preferred -- Work experience in a global role, preferred Certification Requirements: -- TDWI and/or DAMA certifications desired -- Familiarity with Kimball's Dimensional Modeling desired

Keywords: EY, Alpharetta , EDW Technical Lead, IT / Software / Systems , Alpharetta, Georgia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Field Service Technician
Description: EOC1 is a leading provider of controlled environmental testing and certification services and is adding positions due to continued growth. Our services cover a wide range of industries including hospitals, (more...)
Company: EOC1
Location: Atlanta
Posted on: 04/15/2021

Remote UAT Frontend QA Automation Developer
Description: The largest global bitcoin exchange is in need of a Remote UAT Frontend QA Automation Developer. Candidates will
Company: VirtualVocations
Location: Stone Mountain
Posted on: 04/15/2021

Cable Installer
Description: It's your turn to take the lead and deliver the future before anyone else. You'll introduce our customers to AT T's award-winning TV service and state of the art technology while creating a best in class (more...)
Company: AT&T
Location: Decatur
Posted on: 04/15/2021


Sales Associate - Technology dept.
Description: WE ARE OFFERING ELIGIBLE CANDIDATES A ONE-TIME 300 HIRING BONUS br br Grow With Us br br Hudson is North America's leading travel retailer. For over 30 years, Hudson has met the needs and wants (more...)
Company: Hudson Group
Location: Palmetto
Posted on: 04/15/2021

Manager, IT Support
Description: Manager, IT SupportLocation:Atlanta, GAPosition Type:Full-time, ExemptMain Purpose:Function as a hands-on Manager responsible for overseeing Corporate IT User Support services for all of Encompass' corporate (more...)
Company: Encompass Digital Media
Location: Atlanta
Posted on: 04/15/2021

Technology Operations Leader
Description: Are you a creative thinker with strong and diligent execution A passionate worker that thrives on building and nurturing meaningful partnerships Would you like to help Novelis bring new technologies (more...)
Company: Novelis
Location: Kennesaw
Posted on: 04/15/2021

Software Engineer, Proof of Concept (POC)
Description: Overview br br Itential provides powerful network automation software to companies worldwide, from Fortune 500 telecommunications and financial services companies, to enterprises of all sizes. We (more...)
Company: Itential
Location: Atlanta
Posted on: 04/15/2021

Cable Installer
Description: It's your turn to take the lead and deliver the future before anyone else. You'll introduce our customers to AT T's award-winning TV service and state of the art technology while creating a best in class (more...)
Company: AT&T
Location: Buford
Posted on: 04/15/2021

Telecommute Senior .Net Developer
Description: A boutique staffing agency has an open position for a Telecommute Senior .Net Developer. Individual must be able to fulfill
Company: VirtualVocations
Location: Decatur
Posted on: 04/15/2021

Remote Software Test Engineer
Description: A cryptocurrency company has an open position for a Remote
Company: VirtualVocations
Location: Norcross
Posted on: 04/15/2021

Log In or Create An Account

Get the latest Georgia jobs by following @recnetGA on Twitter!

Alpharetta RSS job feeds