WestSacramentoRecruiter Since 2001
the smart solution for West Sacramento jobs

Senior Data Warehouse Technical Lead

Company: Gainwell Technologies
Location: West Sacramento
Posted on: January 12, 2021

Job Description:

Job Description:Essential Job FunctionsThe primary role will be to provide technical leadership to support the operations and continuing development of a newly designed SQL Server data warehouse.The secondary role will be to develop new SSIS packages, stored procedures, SSRS and Power BI objects.* Assists and guides the team through tasks to analyze, improve, and tune existing scripts, ETL, dashboards, and reports.* Coach team members, and assist with direction setting for tasks, including working with the project manager to keep work on track across the team.* Provides SSIS and data-model design guidance, in line with the overall data warehouse architecture.* Create data-models and structures which support analytical applications; mostly normalized but some star schemas.* Works with DBAs, Network Administrators (firewall and port) and System Administrators on other teams to cooperatively resolve technical roadblocks.* Develops new SSIS and/or code to obtain data from sources and move it through the data warehouse layers using the MS BI stack including SSIS, T-SQL/stored procedures, and batch files.* Must demonstrate an understanding of how to use a variety of data sourcing methods. Including:* How to receive, load and archive text data files;* How to ingest/unpack incoming emails (a semi-structure source), move the email to the DW application server, and successfully create loads to put that data into the warehouse tables; and* How to receive Excel spreadsheets via email, move the XSLX attachment to the DW application server, and successfully load the file into a warehouse table.Qualifications* BS Degree CS or MIS or equivalent experience in related roles* 5+ years of experience delivering solutions utilizing the Microsoft BI stack, with a direct experience with SSIS and batch file creation required.* 5+ years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers and user defined functions.* 5+ years of Microsoft SQL Server database development (TSQL) experience* 5+ years of demonstrable experience working in a data warehouse environment (Kimball/Inmon), and ETL concepts as seen in a traditional data warehouse environment (landing zone, stage tables, warehouse, data-marts, presentation)* Working experience with SSRS and Power BI is desired.* Working experience, including administration and security groups, with the Power BI Portal is desired.* Ability to excel in a collaborative and distributed/remote team environment* Proven strong problem-solving skills, troubleshooting, and root cause analysis.

Keywords: Gainwell Technologies, West Sacramento , Senior Data Warehouse Technical Lead, Other , West Sacramento, California

Click here to apply!

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

I'm looking for
in category
within


Other Other Jobs


Loan Underwriter
Description: Join a reputable mortgage company that offers a direct hire, six-figure income opportunity with
Company: Caliber Home Loans
Location: Petaluma
Posted on: 01/20/2021

Remote Sr. Loan Officer - NMLS Licensed
Description: Job DescriptionMinimum Qualifications Must have passed SAFE/UST Licensing Exam Minimum of 1 year of recent, proven success as a Loan Officer in a high-volume setting Minimum of 2 active individual (more...)
Company: Quicken Loans
Location: San Ramon
Posted on: 01/20/2021

Part Time Senior Supervisor - Hiring Immediately
Description: Senior SupervisorAre you outgoing and enthusiastic about interacting with people If promoting the best brands to today's shoppers sounds appealing, then Club Demonstration Services CDS , the in-house (more...)
Company: Club Demonstration Services
Location: San Rafael
Posted on: 01/20/2021


Get New Landscaping Work Today - Preview Leads In Your Area
Description: Over 25 million homeowners have trusted HomeAdvisor 1800Contractor to help them find quality professionals with the expertise to turn their home improvement
Company: HomeAdvisor
Location: Woodland
Posted on: 01/20/2021

Flexible Schedule - Deliver with Uber Eats
Description: Job DescriptionDeliver with Uber. Earn on your schedule. Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekends--it's up to you. Earn Good Money. You'll
Company: Uber Eats
Location: Rohnert Park
Posted on: 01/20/2021

Drive on Your Schedule
Description: Job DescriptionDrive with Uber and earn money anytime it works for you. Driving is an easy way to earn extra, and it's totally flexible around your schedule. You decide when and how much you drive. What (more...)
Company: Uber
Location: Woodland
Posted on: 01/20/2021

Flexible Schedule - Deliver with Uber Eats
Description: Job DescriptionDeliver with Uber. Earn on your schedule. Deliver with Uber Eats on your schedule. Deliver for a few hours in the mornings, every night, or just on weekends--it's up to you. Earn Extra (more...)
Company: Uber Eats
Location: Petaluma
Posted on: 01/20/2021

Make up to $21/hour - Deliver with DoorDash
Description: Your time. Your Goals.What is DoorDashAvailable in over 4,000 cities in the U.S., Canada, and Australia, DoorDash is about connecting people with possibilities: bigger savings accounts, wider nets, stronger (more...)
Company: Doordash
Location: San Ramon
Posted on: 01/20/2021

Food Delivery - Weekly Pay
Description: Job DescriptionDeliver with Uber. Earn on your schedule. Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekends--it's up to you. Earn Good Money. You'll
Company: Uber Eats
Location: Petaluma
Posted on: 01/20/2021

Lot Associate
Description: Job DescriptionLot Associates assist customers with the loading of their vehicles and also monitor
Company: The Home Depot
Location: San Ramon
Posted on: 01/20/2021

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

West Sacramento RSS job feeds