Search Jobs

We’ll help you find your dream job
 

Lead SQL/Database Developer

Chicago, IL
Full-Time
Salary Range : $0

Reporting to the Senior Technologist of Data Team, this person’s primary responsibility will focus on developing SQL queries, SSIS packages, stored procedures, enhancing and maintaining data warehouse load process, etc. This person will manage the gathering of requirements from a backend SQL perspective and implement the necessary and required business logic to transform the business requirements in SQL to provide the desired outcome.

This person will also undertake any duties involved with query optimizations and performance tuning of various MS BI objects, collaborating with business analysts and business stakeholders to ensure a thorough understanding of strategic data requirements and ensuring that the data hub is following the best practices in every aspect.

RESPONSIBILITIES

  • The primary responsibility will focus on developing SQL queries, SSIS packages, stored procedures, data warehouse load process
  • Tune and optimize current ETL jobs for performance and throughput
  • Apply business and database analysis skill to gain deep understanding of user’s needs and aid in the definition and creation of solutions that meet the needs of the business users
  • Comprehensive documentation of all developed software and repositories and assist in documenting and maintaining requirement specification document
  • Gather user requirements and functional specifications along with understanding and interpreting business requirements
  • Assist with troubleshooting efforts for ETL job issues related to pre-production and production
  • Develop custom database objects, stored procedures, functions, and T-SQL
  • Design and implement SSIS packages and other ETL processes
  • Communicate the status of project and planning activities with customers and team members
  • Analyze existing SQL queries for performance improvements
  • Data mapping, transformation and performing ETL based on complex logic
  • Troubleshoot slow performing queries and ETL load process
  • Enhance and support data warehousing and data management projects along with ETL development
  • Responsible for query optimizations and performance tuning of various MS BI objects
  • Design system integrations as required for extracting data for reporting purposes
  • Mapping of data sources, data movement and reconciliation with the goals of ensuring data quality & consistency and the ability to satisfy relevant business requirements by following best BI practices
  • Collaboration with business analysts and business stakeholders to ensure a thorough understanding of strategic data requirements
  • Data analysis / data profiling to understand gaps, inconsistencies and other quality issues in existing source system data, and develop data sourcing solutions, as well as collaborating with stakeholders to identify, document and implement corrections / business rules / workarounds
  • Ability to set and manage own priorities effectively in a dynamic and high performing team
  • Seen as the subject matter expert for all SQL and SSIS related best practices and implementation

QUALIFICATIONS

  • Bachelor’s Degree in computer science, information technology; advanced degree highly preferred
  • 7 + years’ of Experience in Database Management/Data Modeling
  • 7+ years’ work experience in SQL Development including- SQL Server 2012, 2016 and Visual Studio 2015 with advanced programming skills
  • 7 + years of Experience in ETL and in designing and coding SSIS packages
  • 5-7 years of experience in SQL Server Performance Tuning and Query Optimization
  • Experience writing complex Stored Procedures, Functions, and views using SQL
  • Experience working in Azure cloud environment is a plus
  • Experience with Database Administrator roles (backup, restore, security) a plus
  • Sound understanding of relational and non-relational databases
  • Must be able to communicate with business users in non-technical terms. Experience with the Financial Services industry is desired
  • Excellent organization and communication skills with the ability to work on multiple projects simultaneously and within expected timeframes
  • Excellent analytical, problem-solving and decision-making skills
  • Proactive and forward-thinking attitude and creative problem-solving ability
  • Ability to work independently in an entrepreneurial, fast-paced environment
  • Demonstrated team player; supports a One-Team culture
  • Demonstrated values of collaboration, transparency, empowerment and accountability

REQUIREMENTS

  • You must have unrestricted authorization to work in the United States
  • You must be willing to comply with pre-employment screening, including but not limited to drug testing, reference verification, and background check
  • You must be willing to work from the Chicago office
  • You must be willing to travel when business needs rise (<10%)

Share this Job

Apply Now

Upload requirements