IT Report Analyst at Vaco, LLC
Pittsburgh, PA
About the Job
We currently have a direct hire opportunity available for an experienced IT Report Analyst/Writer
This role is primarily remote with minimal as needed onsite requirements
This individual needs to be in the Pittsburgh market
This role offers a competitive salary, benefits, and PTO.
The IT Report Analyst/Writer will be responsible for following software development lifecycle (SDLC) practices for planning, analysis, development, testing, and deployment of reports for the organizations business units
This individual will interact with peers, business leads and others to define requirements, develop data extracts and design reports
This person will develop reports on several technology platforms available at the organization including MS SQL Server, Thomson Elite Enterprise and Datafusion Intellistat solutions
Responsibilities:
Essential Duties:Gather report requirements
Design ETL scripts, reports, OLAP cubes
Test reports, scripts, and other reporting artifacts
Resolve data and report design issues
Implement and maintain reports
Function as project lead and technical liaison for business-driven requests and analysis
Collaborate with other technical team members to identify the best reporting platform for the requirement
Contact the source data owners to coordinate the accurate transfer of data or data requests
Additional Duties:Write SQL language queries to support Elite Enterprise and other integrated applications
Assist with data integration and data migration activities
Work with stakeholder departments to determine systems and software requirements for new reporting solutions and products
Develop and document operational procedures and processes around maintenance and support of systems for hand-off to first and second tier supports teams
Provide technical mentoring and training to other IT resources
Experience and Skills:
Required:3-5 years minimum related experience (If less than 5 years of experience than 4 year degree from an accredited college or university in related field is required)
Expertise in MS Office Suite including SSRS
Extensive experience using SQL
Strong MS Excel experience
Business Acumen
Ad hoc experience
Nice to haves: SSIS and SSAS
Elite Enterprise (or 3E)
PowerBI, DAX, or MDX
Law firm experience
Vaco values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco LLC and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals
As part of this commitment, Vaco LLC and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations
If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact
Vaco also wants all applicants to know their rights that workplace discrimination is illegal
By submitting to this position, you agree that you will be giving Vaco the exclusive right to present your as a candidate for the foregoing employment opportunity
You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications
You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application
In exchange, Vaco agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco LLC and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco”) respects your privacy and are committed to providing transparent notice of our policies
California residents may access Vaco’s HR Notice at Collection for California Applicants and Employees here.
Virginia residents may access our state specific policies here.
Residents of all other states may access our policies here
Canadian residents may access our policies in English here and in French here.
Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco depends upon a wide array of factors including but not limited to:
the individual’s skill sets, experience and training;
licensure and certification requirements;
office location and other geographic considerations;
other business and organizational needs.
With that said, as required by local law, Vaco believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure
The individual may also be eligible for discretionary bonuses.
This role is primarily remote with minimal as needed onsite requirements
This individual needs to be in the Pittsburgh market
This role offers a competitive salary, benefits, and PTO.
The IT Report Analyst/Writer will be responsible for following software development lifecycle (SDLC) practices for planning, analysis, development, testing, and deployment of reports for the organizations business units
This individual will interact with peers, business leads and others to define requirements, develop data extracts and design reports
This person will develop reports on several technology platforms available at the organization including MS SQL Server, Thomson Elite Enterprise and Datafusion Intellistat solutions
Responsibilities:
Essential Duties:Gather report requirements
Design ETL scripts, reports, OLAP cubes
Test reports, scripts, and other reporting artifacts
Resolve data and report design issues
Implement and maintain reports
Function as project lead and technical liaison for business-driven requests and analysis
Collaborate with other technical team members to identify the best reporting platform for the requirement
Contact the source data owners to coordinate the accurate transfer of data or data requests
Additional Duties:Write SQL language queries to support Elite Enterprise and other integrated applications
Assist with data integration and data migration activities
Work with stakeholder departments to determine systems and software requirements for new reporting solutions and products
Develop and document operational procedures and processes around maintenance and support of systems for hand-off to first and second tier supports teams
Provide technical mentoring and training to other IT resources
Experience and Skills:
Required:3-5 years minimum related experience (If less than 5 years of experience than 4 year degree from an accredited college or university in related field is required)
Expertise in MS Office Suite including SSRS
Extensive experience using SQL
Strong MS Excel experience
Business Acumen
Ad hoc experience
Nice to haves: SSIS and SSAS
Elite Enterprise (or 3E)
PowerBI, DAX, or MDX
Law firm experience
Vaco values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco LLC and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals
As part of this commitment, Vaco LLC and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations
If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact
HR@vaco.com
.Vaco also wants all applicants to know their rights that workplace discrimination is illegal
By submitting to this position, you agree that you will be giving Vaco the exclusive right to present your as a candidate for the foregoing employment opportunity
You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications
You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application
In exchange, Vaco agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco LLC and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco”) respects your privacy and are committed to providing transparent notice of our policies
California residents may access Vaco’s HR Notice at Collection for California Applicants and Employees here.
Virginia residents may access our state specific policies here.
Residents of all other states may access our policies here
Canadian residents may access our policies in English here and in French here.
Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco depends upon a wide array of factors including but not limited to:
the individual’s skill sets, experience and training;
licensure and certification requirements;
office location and other geographic considerations;
other business and organizational needs.
With that said, as required by local law, Vaco believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure
The individual may also be eligible for discretionary bonuses.
