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
Data Synchronization Specialist.Ensure vendor data and Medline data are in sync by overseeing and analyzing dozens of different data points/reports.Routinely involves judgement calls, exercising di... Show more
Data Engineer<br /> Duration: 6-12 months<br /> Location: Hybrid Chicago - IL</div> <div>Work Type: <br /> Rate: Pay range offered to a successful candidate will be ba... Show more
The OpportunityHyatt seeks an enthusiastic Senior Database Administrator to join our Corporate Information Technology department, where you will join a team of six professionals who love what they ... Show more
We cordially invite you to apply.Joining our team provides exceptionally distinctive benefits, including: .Medical, dental and vision coverage.Multiple insurance options, wealth benefits and flexib... Show more
Analyst, Manufacturing Support, Warehouse-5.Location: 7300 South Kedzie Ave, Chicago, IL 60629.You will execute warehouse operations in terms of service, cost, health and safety, quality, food defe... Show more
Must be legally authorized to work in the United States for any employer without sponsorship.Java Spring Boot microservices.The ideal candidate will have a deep understanding of microservice design... 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
Vice President, Cloud Data Engineering.Top-tier organization in the consumer services industry.The Company is seeking a VP of Engineering to lead its dynamic and innovative engineering teams.The su... 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
Farmer’s Fridge makes fruits and vegetables accessible and approachable for everyone.We offer a variety of fresh, healthy, ready-to-eat meals and snacks through our fresh food vending machine... Show more
Job Title :Data Architect Enterprise Data Warehouse ( EDW ) Location :Remote Duration :12 Months Job Summary We are seeking an experienced Data Architect to provide architectural leadership and sup... Show more
Job DescriptionArthur Grand Technologies is currently seeking a highly motivated and skilled Healthcare Business Analyst -Long Term Contract - Chicago, IL Remote for one of our clients.Role- System... Show more
A leading IT consulting firm is seeking a skilled Data Analyst to join its Product Analytics team in Chicago.The role involves analyzing complex datasets, ensuring data integrity, and using data vi... Show more
We are a global leader in food & beverage ingredients.Pioneers at heart, we operate at the forefront of consumer trends to provide food & beverage manufacturers with products and ingredients that w... Show more
Blue Orange Digital is a data and AI consulting firm that helps companies turn complex data into real business outcomes.We partner with organizations across industries to design and deploy scalable... Show more
A leading energy solutions provider is seeking a Sales Manager for Data Centers to drive strategic sales initiatives in the data center sector.The role involves leading a remote sales team, buildin... 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
Do you have what it takes to be part of the Wings & Rings crew?.This isn’t your typical restaurant job.W&R is the kind of place for people who love good food and love to show people a good time.Int... Show more
Overview The Director of Sales – Data Center Services is responsible for driving revenue growth across colocation, cloud infrastructure, connectivity, and managed data center offerings.This l... 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
