SQL Server Developer
Keylent IncChicago, IL, United States[job_card.full_time]
Location: Dallas TX / Chicago IL.Experience with full stack web development HTML/CSS/C#/.[internal_linking.show_more]
Data Warehouse Lead / SQL Server SpecialistMavens Guild • Chicago, United States
Data Warehouse Lead / SQL Server Specialist
Mavens Guild • Chicago, United States
[job_card.30_days_ago]
[job_preview.job_type]
- [job_card.full_time]
[job_card.job_description]
What you will need to bring to the table:
What we would like to see:
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***
A typical day as a Data Warehouse Lead/SQL Server Specialist:
-
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
What you will need to bring to the table:
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
[job_alerts.create_a_job]
Data Warehouse Lead / SQL Server Specialist • Chicago, United States
[internal_linking.similar_jobs]
Azure - Sr. Data Engineer
The Planet GroupChicago, IL, United States[job_card.full_time]
Local candidates only - in-person interview is a MUST.Location - Chicago Downtown - onsite Tue, Wed and Thu.Design, build, and support end-to-end data pipelines (ingestion, transformation, validati...[internal_linking.show_more]
Enterprise Architect - Must have SAP TCS DataSure experience
Talent Search PROChicago, IL, United States[job_card.full_time]
Proficiency in major cloud providers like Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP).Operating Systems & Programming.Expertise in operating systems and programming ...[internal_linking.show_more]
SAP Data and Analytics Lead
KomatsuChicago, Illinois, United States[job_card.full_time]
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...[internal_linking.show_more]
Senior Data & Platform Support Engineer
Federal Reserve SystemChicago, IL, United States[job_card.full_time] +1
Federal Reserve Bank of Atlanta.Federal Reserve Financial Services (FRFS) delivers a suite of payments services to financial institutions via FedLine® Solutions, Fedwire® Funds and Securities, the ...[internal_linking.show_more]
AVP, Solutions Data Architecture
VizientChicago, IL, United States[job_card.full_time]
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...[internal_linking.show_more]
Data Center Site Lead, JoinOCI
OracleChicago, IL, United States[job_card.full_time]
Independently responsibility for one or more data centers, leading performance analyses across key operational areas and proactively monitoring facility health to implement significant enhancements...[internal_linking.show_more]
Lead Data Engineer (Java, Snowflake, AWS)
Capital One Financial CorpChicago, IL, United States[job_card.full_time] +1
Lead Data Engineer (Java, Snowflake, AWS).Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and ...[internal_linking.show_more]
Data Support and Visualization Lead
OrisonChicago, IL, United States[job_card.full_time]
Job Title: Data Support and Visualization Lead.Lead a team of support analysts in providing timely and effective support for Data Reporting and Visualization tools such as Tableau, SSRS, Qlik, Powe...[internal_linking.show_more]
Cloud Data Architect Lead — Snowflake, GCP & ELT
SIDRAM TECHNOLOGIESChicago, IL, United States[job_card.full_time]
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...[internal_linking.show_more]
SAP Datasphere
Diverse LynxChicago, IL, United States[job_card.full_time]
We are looking for an experienced SAP Datasphere and SAP Analytics Cloud (SAC) professional to design, build, and deliver enterprise-grade analytics and planning solutions.The role involves integra...[internal_linking.show_more]
MS SQL Server Azure DBA-Chicago, IL
Georgia IT IncChicago, IL, United States[job_card.full_time]
Good Knowledge on MS SQL Server 2017 and above database administration.Working Knowledge of cloud migration and HA/DR set up.Working Knowledge on AOAG set up at Azure Cloud.Working knowledge on set...[internal_linking.show_more]
Senior Data & Platform Support Engineer
Federal Reserve BankChicago, IL, United States[job_card.full_time] +1
Federal Reserve Bank of Atlanta.Federal Reserve Financial Services (FRFS) delivers a suite of payments services to financial institutions via FedLine® Solutions, Fedwire® Funds and Securities, the ...[internal_linking.show_more]
Senior SQL Developer
Macpower Digital Assets EdgeChicago, IL, United States[job_card.full_time]
We are seeking a highly motivated Senior SQL Developer with strong technical and analytical skills.Experience in property and casualty (P&C) insurance is preferred.This role involves system analysi...[internal_linking.show_more]
Senior ETL Lead - Informatica PowerCenter & Data Warehouse
nexus IT groupChicago, IL, United States[job_card.full_time]
A technology services company located in Georgia is seeking an ETL Development Lead responsible for developing and supporting ETL code in Informatica PowerCenter.The role involves designing and doc...[internal_linking.show_more]
Data Modeler - BI Analytics & Data Warehouse (Onsite)
The Dignify Solutions, LLCChicago, IL, United States[job_card.full_time]
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...[internal_linking.show_more]
Server (Earn up to $1,500/wk)
HogsaltChicago, IL, United States[job_card.full_time]
Hogsalt,is looking for a dedicated and experienced.Our ideal candidate is passionate about upholding Hogsalt's values of harmony, accountability, and resilience.Successful Hogsalt team members are ...[internal_linking.show_more]
Sr. Azure Data Engineer
Medline IndustriesNorthbrook, IL, United States[job_card.full_time]
Job Summary Job Description Translate business requirements into the appropriate data models that integrate with the overall logical data warehouse.Define business data requirements and create logi...[internal_linking.show_more]