W2 ONLY - UNABLE TO UTILIZE C2C RESOURCES

　　SQL EXPERIENCE REQUIRED

　　Top Skills' Details

　　1 Five years of experience in the data analytics field (this is not a developer or a data scientist but a true analyst)

　　2 Experience pulling, accessing, and writing code in SQL - ex: how to pull specific customer data such as how much a household views a certain show

　　3 Strong problem solving and communication skills - ex: this team will look to this person to help answer questions and solve problems based on the data and presenting back to other internal teams/leadership. Need to be okay inserting into other teams and speaking up.

　　Description:

　　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:

　　sql queries, sql server, communication and analytical skills

　　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.

　　We are an equal opportunity employers and will consider all applications without regard to race, genetic information, sex, age, color, religion, national origin, veteran status, disability or any other characteristic protected by law. To view the EEO is the law poster click here. Applicants with disabilities that require an accommodation or assistance a position, please call 888-472-3411 or email [email protected]. This is a dedicated line designed exclusively to assist job seekers whose disability prevents them from being able to apply online. Messages left for other purposes will not receive a response.