BI SQL Developer

Overview

Who are we? We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company.

Why Us

We believe in cultivating an environment that breeds opportunity and encourages people to be the best version of themselves. Our team members see work as more than just a job—it’s a career built on passion, grit and ambition. From achieving personal success to lifting others up to do the same, we all rise together. We help people achieve their goals—and then some. Our culture is centered around making an impact. We believe in doing what we love and encouraging others to do the same. Whatever direction you’re headed, you’ll find talented, driven and passionate members of the TEKsystems family creating meaningful work.

General Description:

The BI SQL Developer will collaborate with technical and business individuals to create data objects for reporting, analytical and operational dashboards.  Additionally, the candidate will work to provide documentation artifacts to assist business and technical users on the solutions developed.  Working in an Agile environment, develop best in class business intelligence solutions and contribute to a Center of Excellence operating model.

Responsibilities

Essential Job Duties and Responsibilities:

• The main responsibility of the BI SQL developer is the development of SQL database objects for a wide variety of applications and business uses. Build scalable and reusable data architecture that can be scaled based on their organization’s needs.
• Write SQL queries to store, transform, sort, and retrieve data
• This is a highly technical role that incorporates aspects of computer programming, software engineering, and data architecture and management.
• The SQL developer is also responsible for operational maintenance conducting troubleshooting on databases and applications.

• Accurately estimates the level of effort required to complete product features.
• Must possess a high sense of ownership and accountability.
• Ensures agreement and transparency of business requirements and delivery team commitments.
• Anticipates potential impediments and blocking issues and pro-actively attempts to prevent their occurrence

Qualifications

Required Education and/or Experience:

• Must have 8 years experience developing in Oracle, SQL Server and/or Snowflake
• 5 years of experience with SSIS, Informatica or Metallion
• Must have experience developing stored procedures and ETL for warehouse
• BS degree in computer sciences, software design, engineering, information systems, related field or comparable years of experience.
• Understanding of Tableau and WebFocus a huge plus.

Requisite Abilities and/or Skills:

• Must have experience with software used for developing and maintaining systems to store, organize, and access data

• Strong understanding in researching technical issues.
• Proven ability to communicate and present to external and internal clients and their representatives.

• Should have strong SQL / Transact-SQL query skills.
• Perform code inspections and refactor code to meet standards.
• Communicate effectively within both the product delivery and the internal development teams.
• Should have a good understanding of design patterns and application development processes and practices with a focus on reusability.