View Our Website View All Jobs

Technical Lead, Data Warehouse Development

Exsilio has an immediate opening for a Technical Lead to join our Data Warehouse Development team. This is a full-time position, direct-hire, permanent position.

Data Warehouse developers are responsible for designing and developing data warehousing solutions along with leading and mentoring the development team. Employees are expected to work with the latest Microsoft BI tools to create solutions that meet align with our stakeholders business needs.


  • Identify employee opportunities for improvement; proactively mentor employees
  • Perform a 1:1 meeting with team members that identify best practices and areas for improvement.
  • Participate in the assessment of the customer environment and their requirements and documents results properly.
  • Understanding and working with multiple data sources to create a unified solution that implements the client’s business rules and supports their analytical needs.
  • Creating stored procedures, SSIS packages, and using other methods to import/translate/manipulate data.
  • Analyzing potential data quality issues to determine the root cause, and creating effective solutions.
  • Optimize processes involving large data sets to improve performance.
  • Work with stakeholder to understand their business, and make recommendations to help solve problems or improve processes.
  • Deliver high quality projects on time and budget in fast paced environments

Minimum Qualifications:

  • Excellent communication skills (written and oral)
  • Experience leading a team of 3 or more individuals
  • 7+ years of experience working directly with data warehouses.
  • Advanced SQL Server programming and knowledge of data warehousing best practices.
  • 7+ years’ experience on SQL Server Integration Services.
  • Experience with SQL Server agent jobs.
  • Advanced knowledge of OLAP technologies, and dimensional modeling.
  • 7+ years’ experience designing, developing, testing, and supporting of ETL, and OLAP cubes.
  • The ability to extrapolate database schema to meet the business needs of the application.
  • Client-facing presence and excellent business acumen.

Preferred Qualifications:

  • MCSE
  • Knowledge of best practices for database hardware & software configuration.
  • Knowledge of Hadoop, Pig, and/or other big data technologies.
  • Report development experience (SSRS, PowerBI, Excel)
  • Bachelor Degree in Computer Science, Computer Engineering, MIS or Related Field 

 Exsilio's success is grounded in the perfect balance of size and ability; we have the capacity to expertly handle many large enterprise accounts while still being able to move on a dime and change with our client's diverse needs. Our teams carry with them an arsenal of diverse, expert knowledge and fierce dedication to the success of our customers. We're committed to the idea of getting in the trenches with our customers and really understanding their business to achieve the best results. Working at Exsilio isn’t only about working on projects, we always look for opportunities to stay active in the industry whether it be participating in design competitions and hackathons or showcasing your talents in videos, podcasts or blog form. 

Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file