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
Description:
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.
Summary:
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.
Responsibilities:
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
Tableau
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.
Skills:
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