SQL Data Analyst

Job description

Dice is the leading career destination for tech experts at every stage of their careers. Our client, TEKsystems c/o Allegis Group, is seeking the following. Apply via Dice today!

Top three skills:

  • 5-7 years of experience coding in SQL - should be able to extract and manipulate the data, use SSIS do not use SSRS in environment
  • Experience coding in Python - used for analyzing data and writing reports - three years of Python coding experience
  • Experience as a data analyst analyzing, cleaning, and gathering data - be able to handle millions of lines of data

Nice to have - fraud


Project story: this is a temporary role to support as a manager went on paternity leave. Need strong SQL skills, SQL server database management, Python knowledge (used for writing reports and analyzing data), gathering data and analyzing data (able to understand the data and any issues it in and how to clean up and make it useful). Need to have at least 5-7 years of experience. If someone has used a tool as an analyst but hasn't coded that won't work. Not looking for a data modeler or data scientist. Should be able to run pivot tables and visualize the data. Have data in Oracle, SQL, and Hadoop - data comes from different areas then have to synthesize and analyze it. For example, see fraud in a data set then be able to work with the fraud team to build the logic and code to fix it.


This individual is charged with creating and delivering actionable insights that influence business decisions in the areas of strategy business planning competition KPI development and new/existing initiatives for analysis and operational optimization.

In addition to the data and analysis collected and presented to the supported business the expectation is for this individual to use statistical analyses to identify drivers and create strategic recommendations presenting these to key partners.

This position requires an individual who can integrate knowledge of business and functional priorities to act as a key contributor in a complex and crucial environment.


Conduct advanced analysis based on provided requirements utilizing extremely large datasets and complex business requirements that typically involves multiple analytical techniques to drive meaningful change on KPIs and objectives established by the stakeholder. Assist to shape and providing additional value.

Assist management in shaping methodology and baselining showing independence for projects that are a refresh or similar in scope to past team projects. Know what technical tool to use to help lead the discussion.

Incorporate standard best practices for industry measurement and KPIs gauging statistical significance.

Gather data through advanced SQL while querying across multiple platforms and demonstrating an understanding what is necessary for scripts to return relevant data while maintaining performance tuning and best practices

Demonstrate ownership in data gathering source choices and methodology as the SME for common SOT sources

Execute validation checks including data element inconsistencies working with leadership to design and implement solutions also checking against standard business trends to identify outliers

Partner with DQ/architecture shaping requirements and communicating needs to ensure ingests/automations are structured in a way to meet the business goal. Demonstrate the ability to provide basic direction when quality issues or adjustments arise.

Produces an often-complex collection of reports graphs summaries and presentations that convey analytic results in an easy to understand and storied manner and align with business needs. Maintain a focus on flow and context ensuring analysis provides insights that tie to visuals and speaks to drivers and business strategy shifts where appropriate.

Demonstrate the ability to clearly identify key points and callout deeper insights or tie to other visuals and how it relates to business performance through written communication within analysis

Develop appropriate visuals to ensure the story is conveyed with the ability to add in multi-dimensional views beyond standard and recommending product output and design best suited to meet business and stakeholder needs

Review and polish analysis through iterative development focusing on word choice grammar and brand standards as well as seeking out and participating in peer reviews

Understands meeting etiquette following guidance on when to make comments or ask questions with stakeholders

Confidently and respectfully responds to leader and/or stakeholder feedback in presentation

Creates presentation messaging appropriate for the specific audience

Translates methodology and technical elements clearly and concisely

Displays business acumen by leveraging recent or expected business performance when generating requirements

Understands and can speak to annual KPI trends including dependent KPIs. Demonstrates knowledge by identifying a shift from baseline performance and impact on business within analyses

Shows expertise by confidently identifying and speaking to data resources and KPIs components within analysis

Can tie related KPI performance within analysis and identify co-dependent KPIs. Demonstrated by anticipating potential follow-up questions

Understands the importance and basic elements of project planning and can create plan independently

Follows project plan and communicates progress/roadblocks proactively understands level of details required in communication respects project timeline and maintains clear/concise documentation on requirements project goals methodology and output

Initiates relevant SME and POC reviews with leader to ensure buy-in and alignment

Daily utilization of JIRA for tracking all tasks and projects.

Supports all department objectives and participate in work streams processes training etc. as appropriate.

Regular consistent and punctual attendance. Must be able to work nights and weekends variable schedules as necessary.

Other Duties And Responsibilities As Assigned.

Education and Experience Requirements:

Education Level: Bachelor's Degree or Equivalent MBA preferred.

Field of Study: Business Business Intelligence Information Systems Information Sciences Economics Engineering Finance Mathematics Statistics

Years' Experience: Generally requires 3-4 years related experience.

Technical Requirements:

Advanced SQL/Teradata


Advanced PowerPoint/Think-Cell

Advanced Excel

Python/R/Data Modeling optional but preferred

Skill Requirements:

Promote a culture of excellence meaningful data and reporting data driven discussions actionable insights knowledge sharing and teamwork while maintaining an environment that is professionally aggressive.

Ensures all projects and data developed is value adding and provides actionable insights.

Ensure appropriate level of statistical significance in insights help educate and hold stakeholders and team accountable in their design and interpretation of analyses.

Be a hands-on analytical business partner who enjoys rolling up their sleeves to solve complex business questions through data.

Formulates and tests hypotheses weighs alternatives and determines appropriate recommendations for actionable insights.

Demonstrate a commitment to the quality of data sets and reporting created by the team ensuring they are repeatable and sustainable.

Possesses a balance of general business knowledge ability to work with multi-million record relational databases analytical acumen and presentation skills

Performs in depth research on root cause of data anomalies that are uncovered through normal course of analysis.

Designs new methods and best practices for analysis and presentation of comparative data as well as for processes forecasting and planning.

Relentlessly motivated when working with large and complex datasets. Naturally receptive to direct feedback and constructive criticism. Thrives in collaborative team-oriented environment.

Takes a solution focused approach to roadblocks by ensuring possible solutions and paths forward or around are presented

Must have excellent verbal and written communication skills

Ability to listen to and understand customer requests

Task oriented proactive in identifying and adapting to change while maintaining performance.

Solid time management skills and deliverables with high-quality work production that meets deadlines. Demonstrate understanding of project management processes from start to finish and be able to communicate effectively for the success of the team with minimal supervision or oversight from superiors

Demonstrated ability to pick up key concepts and apply them to work. Demonstrated ability to analyze troubleshoot problem solve and provide input on decision making

Exceptional attention to detail and ability to progress multiple projects in parallel and across functions and geographies

Self-starter who is eager to learn and expand their competencies and feels comfortable sharing knowledge across the entire team

Displays active engagement and enthusiasm in meetings including awareness of leveraging electronics and participation in discussion

Serve as a team leader within a work group or on cross-functional teams accepts team lead stretch assignments.


data analysis, tableau, business analysis, reporting, fraud, sql

Top Skills Details:

data analysis,tableau,business analysis,reporting

Additional Skills & Qualifications:

Experience in fraud is a nice to have.

Experience Level:

Intermediate Level

About TEKsystems:

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.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. SQL Data Analyst

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs
March 4, 2024
March 4, 2024

Senior Cloud SQL Data Engineer

March 4, 2024

Senior Cloud SQL Data Engineer