T
Excel/SQL Data Analyst
Salary undisclosed
Apply on
Original
Simplified
Description:
w2 only, uptown onsite 3 days a week
This resource will be responsible for the end to end production support of metric reporting routines for reports/dashboards that are shared with executive leadership.
This resource will be working with advanced excel formulas, need to understand inner and outer joins as well as write complex sql queries. They will be responsible for the tracking/reporting of metrics via data visualization and data graphs for all of the global technology and identify any anomalies or breaches in the data.
Day to Day Duties:
- QA of data tables
- Data aggregation
- SQL fixes so understanding inner and outer joins, and being able to understand and write simple and complex SQL queries.
- Understanding and evaluating high level formulas in Excel.
- extracting data in excel
- Tracking and reporting data metrics
- ability to work in large sets of Data 50,000 to 500,000
Screening Questions:
Skills:
Sql, Data, Sql queries, metrics, Reporting, Data aggregation, vba
Top Skills Details:
Sql,Data,Sql queries,metrics,Reporting,Data aggregation
Additional Skills & Qualifications:
The role provides dashboards and critical end to end production support of metric reporting routines. The
reports/dashboards are shared with senior executives within and outside of the organization to drive proper risk
culture and business strategy. Given the level of the audience, report dashboards and executive summaries
must be pristine and error free. Data dashboarding and data analytics responsibilities may
include, and are not limited to, build or enhancement of Tableau reports and dashboards, Adhoc report creation or
data refresh, import and manipulation of data across varied sources, data mining, trending analysis, data
aggregation, key risk indicator reporting, creating SQL infrastructure to store required data, risk program metrics
analysis, performance/milestone analytics, success analytics to identify areas of discrepancy and possible atrisk
controls, and collaborating with business partners to design and build new reports based on their business
requirements.
Success measures for this role include:
Consistent, timely delivery of report builds or modifications in Tableau environment
Timely delivery of reporting requirements using existing macros and code
Proactive identification of code or macro breaks
Successful application of macro/code fixes and creation
Demonstrated ability translate users' needs into reports or dashboards
Reliable application of advanced Excel and SQL skills to produce reporting in an efficient, timesaving manner
Demonstrated ability capture, manipulate and clean data from multiple sources and systems of record
Ability to remain nimble and positive when priorities change and Adhoc needs arise
Shows a sense of urgency and attention to detail as standard work practice
Strong collaboration
Required Skills:
Moderate-to-advanced Tableau dashboard creation /modification (5+ years)
Moderate-to-advanced SQL skills (5+ years)
Advanced, expert Excel skills (5+ years)
MicroStrategy or other reporting business intel
Experience Level:
Intermediate Level
o Eligibility requirements apply to some benefits and may depend on your job classification and length of employment.
Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role
may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Hybrid onsite uptown 3 days a week
w2 only
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.
w2 only, uptown onsite 3 days a week
This resource will be responsible for the end to end production support of metric reporting routines for reports/dashboards that are shared with executive leadership.
This resource will be working with advanced excel formulas, need to understand inner and outer joins as well as write complex sql queries. They will be responsible for the tracking/reporting of metrics via data visualization and data graphs for all of the global technology and identify any anomalies or breaches in the data.
Day to Day Duties:
- QA of data tables
- Data aggregation
- SQL fixes so understanding inner and outer joins, and being able to understand and write simple and complex SQL queries.
- Understanding and evaluating high level formulas in Excel.
- extracting data in excel
- Tracking and reporting data metrics
- ability to work in large sets of Data 50,000 to 500,000
Screening Questions:
Skills:
Sql, Data, Sql queries, metrics, Reporting, Data aggregation, vba
Top Skills Details:
Sql,Data,Sql queries,metrics,Reporting,Data aggregation
Additional Skills & Qualifications:
The role provides dashboards and critical end to end production support of metric reporting routines. The
reports/dashboards are shared with senior executives within and outside of the organization to drive proper risk
culture and business strategy. Given the level of the audience, report dashboards and executive summaries
must be pristine and error free. Data dashboarding and data analytics responsibilities may
include, and are not limited to, build or enhancement of Tableau reports and dashboards, Adhoc report creation or
data refresh, import and manipulation of data across varied sources, data mining, trending analysis, data
aggregation, key risk indicator reporting, creating SQL infrastructure to store required data, risk program metrics
analysis, performance/milestone analytics, success analytics to identify areas of discrepancy and possible atrisk
controls, and collaborating with business partners to design and build new reports based on their business
requirements.
Success measures for this role include:
Consistent, timely delivery of report builds or modifications in Tableau environment
Timely delivery of reporting requirements using existing macros and code
Proactive identification of code or macro breaks
Successful application of macro/code fixes and creation
Demonstrated ability translate users' needs into reports or dashboards
Reliable application of advanced Excel and SQL skills to produce reporting in an efficient, timesaving manner
Demonstrated ability capture, manipulate and clean data from multiple sources and systems of record
Ability to remain nimble and positive when priorities change and Adhoc needs arise
Shows a sense of urgency and attention to detail as standard work practice
Strong collaboration
Required Skills:
Moderate-to-advanced Tableau dashboard creation /modification (5+ years)
Moderate-to-advanced SQL skills (5+ years)
Advanced, expert Excel skills (5+ years)
MicroStrategy or other reporting business intel
Experience Level:
Intermediate Level
o Eligibility requirements apply to some benefits and may depend on your job classification and length of employment.
Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role
may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Hybrid onsite uptown 3 days a week
w2 only
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job