This position demands a critical understanding of data warehousing concepts, advanced ETL and BI report development skills, and an in-depth knowledge of SQL Server database.
Primary responsibilities of this senior role include leading development efforts of ETL processes and BI reports using Microsoft BI stack (SSIS, SSRS, SSAS) and Tableau, designing relational database structures, prescribing and implementing database development standards, and some SQL server database administration. Ideal team member should be a self-starter, work with minimal supervision and seek-out opportunities to augment existing processes.
***All candidates will undergo stringent technical interview***
Develop and lead development efforts of data integration (ETL) processes and BI reports
Develop and lead development efforts of SQL queries for ad hoc data analysis, data integration processes, audit purposes and performance tuning of production SQL
Develop and lead development efforts of database objects (tables, views, stored procedures, indexes, etc.,)
Implement and administer (Level 1) SQL Server databases across various development and production environments
Implement and administer standards for development and deployment of database objects
Lead implementation efforts of database structures to support enterprise data warehousing activities
Lead implementation efforts of high-availability and disaster recovery environments
Assist data integration teams with data modeling tasks and maintain an inventory of data definitions
Assist and advise in performance tuning of SQL queries
Assist and advise in organization and standardization of existing database structures
Assist and advise in data migration and test data creation
Assist and advise in process automation and scheduling
Assist in data integration activities and collaborate with cross functional teams
8+ years experience of working as a data warehouse developer
Solid experience with data integration and reporting tools like SSIS, SSRS and procedural coding.
Experience with creation of database structures and effective management of all database objects
Experience with implementing database resource governance
Experience with database standards and end user applications
Experience with data backup, recovery, security, integrity and SQL
Substantial experience with standing up development and testing database environments
Good knowledge of database design, documentation and coding
Good knowledge of data warehouse methodologies and best practices
Strong problem solving skills, with an analytical mindset
BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates
Knowledge of working within Agile framework is desired
Knowledge of other relational database systems like Oracle or MySQL is desired
Complimentary skill sets like background in C++, Java, scripting languages, etc., will be a huge bonus
Data Warehouse Lead / SQL Server Specialist • Chicago, United States
Proficiency in major cloud providers like Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (Google Cloud Platform).Strong knowledge of network architecture, cybersecurity, data... Show more
A leading consulting firm in Chicago is seeking an Architect for their Data capability group.In this role, you will lead teams in implementing advanced data solutions and manage various data projec... Show more
Our Winning Family Starts With You! .Check out these great benefits!.Flexible schedules to help you balance other life commitments (school, childcare, family care, etc.Paid Sick Leave (1 hour for e... Show more
A leading technology firm is seeking a Data Architect to design and manage database systems, lead data migrations, and develop ETL pipelines.The ideal candidate will have 5-8 years of experience in... Show more
Having strong analytical reasoning to understand end user’s requirements and able to differentiate between desired and required user needs.Analyse current and future state business processes and ab... Show more
LLC is a Chicago-based nutrition company that creates great-tasting, nutrition-rich and dairy products to nourish consumers.With over $3B in annual retail sales, fairlife's portfolio of delicious, ... Show more
We’re making security suck less for developers.Security tools haven’t kept up with how software is built today.They interrupt teams, slow releases, and turn security into a bottleneck instead of a ... Show more
Sr Project Controls Professional.At Jacobs, we're challenging today to reinvent tomorrow by solving the world's most critical problems for thriving cities, resilient environments, mission-critical ... Show more
As a Business Systems Analyst, you will transform, maintain, and enhance Oracle Fusion, Oracle EBS, and associated applications to meet Finance business needs.This role involves global, cross-funct... Show more
This is a full-time, on-site position where you'll support critical infrastructure at world-class data center facilities.Comprehensive benefits package including:.Health, dental, and vision insuran... Show more
Our Servers are motivated, team oriented, friendly, dependable and driven to providing excellent guest service.A qualified candidate will greet and seat guests, suggestive-sell, take orders, prep f... Show more
G3 Enterprises Job Applicant Privacy Notice.G3 Enterprises is an industry leader in packaging, logistics, real estate and minerals solutions.Our diverse portfolio of businesses create a variety of ... Show more
A leading data solutions firm is seeking a Resource Specialist to lead data governance initiatives.This remote role requires over 10 years of experience in data governance, data mapping, and catalo... Show more
Senior Health & Benefits Consultant, Data Analytics.We are seeking a talented individual to join our Health & Benefits team at Mercer.This role can be based in any US city.This is a hybrid role tha... Show more
Data Analytics Sales Specialist III.As a Data Analytics Sales Specialist, you will help us grow our Data Analytics business by building and expanding relationships with new and existing customers.I... Show more
A leading advertising and marketing agency in Chicago seeks an Associate Director to manage data strategy and drive client innovation.The role requires extensive knowledge of ad technology and digi... Show more
A leading data solutions provider in Chicago is seeking a highly experienced Snowflake Data Architect to lead the design of enterprise data management frameworks.You will develop scalable and secur... Show more
One year of prior leadership, supervisory, or retail key holder work experience.Must be fluent in reading, writing, and speaking English.Prefer the knowledge of store inventory control.The followin... Show more
A leading consulting firm is seeking a Solution Architect who specializes in Azure data and analytics services.The ideal candidate should have over 10 years of experience, with a deep understanding... Show more
Legendary food and service begins with legendary people.We believe in earning the loyalty of our Team Members with our strong, diverse culture, well-done benefits and growth opportunities.It takes ... Show more
