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
Chicago, Illinois, USA, 60631 | Milwaukee, Wisconsin, USA, 53204-2941.Join Komatsu and Be Part of Something Big!.Komatsu is undergoing a major business transformation with the implementation of SAP...Mostrar más
About RethinkFirst RethinkFirst is a leading behavioral health technology company working to make mental wellness, education, and support accessible and scalable.Through our suite of cloud-based pl...Mostrar más
A leading healthcare support organization is seeking a Principal Data Engineer in Chicago to architect and optimize scalable cloud-native data platforms.This role involves leading data engineering ...Mostrar más
A global marketing agency is looking for a VP, Connected Commerce in Chicago to lead retail-specific activities for a major multi-brand client.The role requires over 10 years of experience in shopp...Mostrar más
We’re looking for a Databricks Technical Lead who can guide the design and build‑out of our data engineering and transformation platforms.This person will be the go‑to expert on Databricks, Delta L...Mostrar más
An innovative firm is seeking a detail-oriented SQL Specialist to enhance data validation processes.In this role, you will leverage your deep SQL knowledge to debug complex queries and ensure data ...Mostrar más
Press Ganey is the leading experience measurement, data analytics, and insights provider for complex industries-a status we earned over decades of deep partnership with clients to help them underst...Mostrar más
The American Medical Association (AMA) is the nation's largest professional Association of physicians and a non-profit organization.We are a unifying voice and powerful ally for America's physician...Mostrar más
Kenexai delivers smart, data-driven solutions that empower businesses across industries.Our mission is to combine deep, domain-specific expertise with cutting-edge technology to drive meaningful im...Mostrar más
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...Mostrar más
Hybrid - periodic travel to Newark, DE (2 weeks per month).Must reside or be willing to relocate to TX, IL, NJ, OH, DE, MD, PA, VA, NC, GA, FL.The SAP SCM Technical Lead is responsible for the tech...Mostrar más
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...Mostrar más
Lift Your Career to New Heights with CJ Logistics!.Are you passionate about warehouse operations and ready to make a global impact? At CJ Logistics, we're on the hunt for exceptional talent to keep...Mostrar más
When you're the best, we're the best.We instill an environment where employees feel engaged, satisfied and able to contribute their unique skills and talents while living and working as their authe...Mostrar más
We are seeking a highly experienced Snowflake Data Architect to lead the design and implementation of enterprise data management frameworks.This role involves defining strategic data architecture, ...Mostrar más
A technology company specializing in data and AI seeks a Solutions Architect to lead growth for its analytics platform in Chicago.The ideal candidate will have over 8 years in customer-facing roles...Mostrar más
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...Mostrar más
A technology solutions provider is seeking a Data Modeler specializing in BI Analytics for an onsite full-time position.The ideal candidate will have over 5 years of data modeling experience, exper...Mostrar más
