JOB RESPONSIBILITIES 

System Administration and Maintenance

• Protect the stability of various Pricing and Cost Applications and ensure the integrity of the data involved.

• Assess, coordinate and review issues and impacts to support and business processes.  Analyze, document and communicate application issues to management and programming team.

• Documents business and functional system requirements.  Write SIT, UAT, and regression test scripts. Create necessary SQL scripts and testing evidence to correct system data.

• Responsible for requesting, tracking, testing for all changes needed in the Team Foundation Server Portal.

• Uses customer service skills to identify the root of the problem being reported.  Demonstrates the skill and ability to effectively provide quality support in a high volume environment

• Escalates obstacles/issues in a timely manner.

• Reports project status according to prescribed timelines.

Data Analysis

• Develops business analytics for cost and pricing. Including developing new insights and understanding of business performance based on data and statistical methods.

• Analyzes external market dynamics and internal data sources to assess trends and develop actionable insights. Applies knowledge of data auditing, statistical and quantitative analysis, explanatory modeling, and fact-based management to support recommendations.

• Develops polished executive-level Power BI reports and confidently delivers information in a clear and concise fashion.  

• Coordinate and communicate between business users and the data warehouse organization, balancing requirements and resources to solve business problems.

• Perform extensive data validation/quality assurance analysis within large datasets.  Writes ad hoc reports, builds tabular reports, visualizations, and Excel pivot tables or macros to review and report data.

• Communicates effectively with Corporate and Field users.

MINIMUM REQUIREMENT

Education

• Bachelor’s degree in Computer Science, Information Management, or related discipline.

Experience

• A minimum of three (3) years’ experience as a Technical Analyst, Business Analyst or similar role.

• One (1) year of experience using Power BI to build metrics/KPIs dashboards with refreshable data connections.

Knowledge, Skills and Abilities

• Proficiency in SQL, including writing complex queries, aggregations, subqueries, and joins to extract and manipulate data from relational databases

• Communicates effectively in both written and oral.

• Knowledge in operational business processes and systems.

• Proficient in various software programs, including Excel, Word, Outlook and PowerPoint.

• Experience writing TSQL, view, stored procedures, functions, and triggers.

• Demonstrates knowledge of process improvement

• Understanding of databases, logic views, query tools, and standard file layouts for conversions and interfaces.

• Proven success in a collaborative, team-oriented environment.

• Experience writing Excel VBA macros a plus.

WORK CONDITIONS

Work Environment

• Work indoors during all seasons and weather conditions

• Comply with Corporate dress code policy

Work Postures

• Sitting continuously for many hours per day, up to 6 hours per day

• May climb stairs to access buildings frequently

Physical Demands

• Physical effort requiring manual dexterity is required, includes paperwork, calculators, computers and phone usage

Work Hours

• Working beyond “standard” hours as the need arises