Sr IT Systems Data Analyst - MYR Group

The Sr IT Systems Data Analyst works across teams to understand, model, architect, and document business-critical data for use in wider-scale business analytics, including corporate performance management (CPM), financial planning and analysis (FP&A), and data modeling.

Company Overview

With roots dating to 1891 and 8,500+ employees, MYR Group is a publicly traded holding company of 13 specialty electrical construction companies. MYR Group and our subsidiaries work on large-scale electrical construction projects throughout the U.S. and Canada. We contribute to a clean energy future while fostering a safe, supportive, and inclusive work environment. Our culture is built on shared values and mutual respect, where teamwork and collaboration occur naturally.

Throughout our history, we have partnered with utilities, municipalities, commercial clients, and developers to deliver some of the largest and most notable projects including transmission/distribution/substation, commercial and industrial, storm restoration, and renewable (solar and wind farms) energy. 

Essential Functions

• Make ERP and other critical-source data accessible to those who need the information to streamline business processes (specifically financial data)
  • Extract information from data sources
  • Transform data into usable objects, load into appropriate repository
  • Identify correlations and patterns
• Normalize complex data structures from assorted sources
• Work with stakeholders who use data to predict trends in the finance area and business conditions as a whole
• Perform statistical analysis of data
• Use tools and techniques to visualize data in easy-to-understand formats, such as diagrams and graphs
• Prepare reports and presenting these to management or stakeholders
• Identify and recommend new ways to save money by streamlining business processes based on the data
• Monitor data quality and prune corrupt data
• Communicate with stakeholders to understand data content and business requirements
• Use data to predict trends with construction customers and the construction market as a whole
• May develop user documentation or training materials
• Regular and predictable attendance
• Other duties as assigned
• Essential functions of this position are to be performed at a Company-designated office or field location
• Understand and comply with the Company's Code of Business Conduct and Ethics Policy and other industry-specific professional and ethical standards

Qualifications

• Minimum 8 years of experience in data analysis, architecture and related activities
• Experience with CPM or EPM solutions like Hyperion (Oracle), SAP BPC, or Anaplan preferred
• Strong skills in SQL, particularly in writing complex queries for data analysis and reporting
• Experience with data management and integration (ETL processes), financial models and consolidations

Preferred Education

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Finance and Accounting or a related field from an accredited university or institution

Knowledge/Skills/Abilities

• Possess a combination of technical skills, business analysis expertise, and familiarity with the data modeling, data transformation, and data engineering
• Strong understanding of system and data integration with enterprise resource planning (ERP) systems, such as JD Edwards Enterprise One (E1), system schemas and field mapping.
• Extensive knowledge of technology, workflow management, report building and data visualization
• Extensive understanding of JD Edwards E1 system, applications, data, and data structures
• Working knowledge of FP&A tools such as OneStream, Anaplan, Hyperion, etc.
• Working knowledge of data lake/data warehouse tools such as Informatica, Databricks, Snowflake, etc.
• Ability to understand complex database systems
• Strong organizational & time-management skills with the ability to handle multiple tasks
• Sound knowledge of documentation procedures, programming procedures and methods, operator instructions, and program flow charts
• Proven ability to provide solid customer service and exercise diplomacy
• Solid verbal and written communication skills

CCompensation & Benefits

• Salary $120,000-$135,000 / year
  • Commensurate with experience, paid weekly. Posted salary ranges are made in good faith. MYR Group reserves the right to adjust ranges depending on the qualifications of the selected candidate.
• Two days per week remote work option for non-field roles depending on position and performance.
• Comprehensive benefits package - Medical, Basic Vision, Regenexx, Teledoc, Hearing, Mental Health (Low deductibles and out-of-pocket maximums) - Fifteen Dollar weekly premium for employee or employee plus family coverage.
• Dental – 100% employer-paid premium.
• ThrivePass Health & Wellness Reimbursement Program - Twelve hundred dollars annually for health and wellbeing-related purchases.
• Annual Paid Time Off starting at 15 days plus 10 paid Holidays (Cultural Celebration Day is a floating holiday).
• Generous 401(k) Plan with 100% match up to 6%; immediate vesting, and Annual profit-sharing potential.
• Superior educational assistance program (support for educational costs, internal training, and more!).
• Company-paid short and long-term disability, life, and accidental death & dismemberment.
• Company-paid business travel accident insurance.
• Employee Assistance Plan (EAP).
• Various voluntary plans available including supplemental vision, accident and critical illness, ID theft, group legal, group auto & home, and additional voluntary life insurance plans for employees and dependents.

Position may be subject to pre-employment screening, which may include background check and drug testing. Accessibility: If you need an accommodation as part of the employment process, contact our Employment Hotline at 1-855-635-1321.

MYR Group, Inc. and our subsidiaries are proud to be Equal Opportunity Employers. We promote diversity of thought, culture, and background, which connects our family of brands. We are committed to a work environment that supports, inspires, and respects all individuals and in which personnel processes are merit-based and applied without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, or other protected characteristics. We celebrate diversity and are committed to creating an inclusive environment for all employees.

MYR Group does not sponsor applicants for work visas. Applicants must be currently authorized to work in the United States for any employer.

MYR Group, Inc. and our subsidiaries do not work with any third-party recruiters or agencies without a valid signed agreement and partnership with the Corporate Talent Acquisition Team.