Data and Reporting Analyst

The Science Technology Partnerships and Outreach (S&TPO) directorate at Argonne National Laboratory plays a pivotal role in driving innovation, fostering partnerships, and connecting groundbreaking research to the broader innovation ecosystem. By catalyzing collaborations and capturing new opportunities, S&TPO supports Argonne’s mission to ensure U.S. competitiveness, economic prosperity, and national security.

We are seeking a Data and Reporting Analyst to ensure data integrity, accuracy, and quality, who is astute in advanced reporting capabilities and has demonstrated skills in querying and manipulating data to support strategic process and business insights.  In this role, you will gather and analyze data from enterprise systems that house various agreement types including sponsored research agreements and intellectual property agreements, and you will prepare and transform data from various sources for complex reporting and ensure seamless integration into the data warehouse. This position primarily involves data hygiene and conducting complex data analyses, developing sophisticated reports and creating visualizations to enhance the effectiveness of partnership initiatives and outreach activities. In this role, you will foster collaborative and strategic partnerships with key stakeholders using proactive communication and joint problem solving to ensure alignment across teams to address evolving business and data requirements for optimal data accessibility and accuracy. 

All S&TPO employees are expected to demonstrate commitment to the strategic and ethical integration of Artificial Intelligence (AI) across all roles within the organization, aiming to enhance productivity and efficiency.

Key Responsibilities:

• Develop standardized report information and prototypes while partnering with Argonne's Business and Information Systems (BIS) team to populate, maintain, and enhance production data sources, and coordinate efforts on the development and testing of internal reporting enhancements.

• Create, maintain, and analyze complex and detailed reports for diverse stakeholders, ensuring compliance with Argonne procedures, business rules, and DOE requirements.

• Produce audit reports to reveal necessary system or process updates for improved data accuracy, use advanced analytical techniques to uncover trends, patterns, errors, and non-compliant outputs, and recommend corrective actions, while interfacing with process owners, software vendors, and BIS to maintain data integrity and troubleshoot system deficiencies that impede data accuracy.

• Enhance data integrity and accuracy within databases by leveraging a comprehensive technical understanding of data structures, sources, and flow dynamics.

• Design and implement relational database schemas and data models to support business requirements.

• Utilize project management skills to lead stakeholder coordination, communication and resource and risk management.

• Interface with S&TPO leadership and other stakeholders to understand and provide reporting solutions that support their needs and objectives while engaging with BIS team on S&TPO’s BI and data integration solutions across cloud and on-premises systems. 

• Support S&TPO Operations Director with understanding data trends and needs while collaborating with BIS, other BI offices, and information governance teams at Argonne on best practices to enhance data efficiency and effectiveness.

Position Requirements

Qualifications

• Education:

  • Bachelor’s degree in Data or Computer Science, Business Analytics, Information Systems, or a related field; Master’s degree preferred.

  • Certifications in SQL, Power BI, Python, Tableau, etc are highly desirable.

• Experience:

• Professional experience in a Data Analyst or similar role, preferably within a research institution or technology company.

• Experience in building data models and data warehousing schemas and working with various data sources and technologies.

• Experience within a sponsored research, university technology transfer office, or national laboratory setting is preferred, but not required.

• Technical Skills:

  • Proficiency in SQL and experience with database management systems like SQL Server, Oracle, or similar.

  • Proficient knowledge of ETL tools.

  • Familiarity with enterprise and contract/patent databases such as Workday, InfoEd, Anaqua, Inteum, or similar platforms is a plus.

  • Experience in Agile (Scrum) methodologies.

  • Proven knowledge of data visualization techniques and systems (PowerBI, Tableau or similar.)

  • Exceptional ability to synthesize complex data sets into actionable insights.

  • Clear communication and interpersonal skills, with the ability to collaborate effectively with stakeholders with diverse technical skills and data needs.

  • Focused attention to detail and excellent problem-solving abilities.

Other:

The selected candidate will be placed at the appropriate level (PT3 or PT4) depending upon the depth and breadth of relevant knowledge, skills, and experience brought to the position. The requirements for the desired levels are as follows:

• PT3- Bachelor’s Degree and 4+ years of relevant experience, or equivalent

• PT4- Bachelor’s Degree and 6+ years of relevant experience, or equivalent

This position description documents the general nature and level of work but is not intended to be a comprehensive list of all activities, duties and responsibilities required of job incumbent. Consequently, job incumbent may be required to perform other duties as assigned.

Job Family

Professional Technical (PT)

Job Profile

Data Management 3

Worker Type

Regular

Time Type

Full time

The expected hiring range for this position is $83,264.00 - $131,343.03.

Please note that the pay range information is a general guideline only. The pay offered to a selected candidate will be determined based on factors such as, but not limited to, the scope and responsibilities of the position, the qualifications of the selected candidate, business considerations, internal equity, and external market pay for comparable jobs. Additionally, comprehensive benefits are part of the total rewards package.

Click here to view Argonne employee benefits!

As an equal employment opportunity employer, and in accordance with our core values of impact, safety, respect, integrity and teamwork, Argonne National Laboratory is committed to a safe and welcoming workplace that fosters collaborative scientific discovery and innovation. Argonne encourages everyone to apply for employment. Argonne is committed to nondiscrimination and considers all qualified applicants for employment without regard to any characteristic protected by law.

Argonne employees, and certain guest researchers and contractors, are subject to particular restrictions related to participation in Foreign Government Sponsored or Affiliated Activities, as defined and detailed in United States Department of Energy Order 486.1A. You will be asked to disclose any such participation in the application phase for review by Argonne's Legal Department.  

All Argonne offers of employment are contingent upon a background check that includes an assessment of criminal conviction history conducted on an individualized and case-by-case basis.  Please be advised that Argonne positions require upon hire (or may require in the future) for the individual be to obtain a government access authorization that involves additional background check requirements.  Failure to obtain or maintain such government access authorization could result in the withdrawal of a job offer or future termination of employment.