Data & Reporting Analyst / Management Analyst Staff Specialist jobs in United States
cer-icon
Apply on Employer Site
company-logo

State of Minnesota · 13 hours ago

Data & Reporting Analyst / Management Analyst Staff Specialist

The State of Minnesota is a mission-focused financial institution committed to equity and inclusion. They are seeking a Data & Reporting Analyst who will support reporting and analytics efforts, ensure data accuracy and integrity, and assist business users with data-related changes to drive data-informed decision-making.

Government Administration
check
H1B Sponsor Likelynote

Responsibilities

Independently analyzes reporting needs identified by division management and program teams to support operational and management goals. Partner with business users, program teams, and leadership to understand needs and translate them into reporting and analytical solutions
Develop, maintain, and deliver recurring and ad hoc report requests from multiple locations such as databases, servers and the data lake (future). Partner with Stakeholders to ensure that reports and analysis are accurate, produced timely, meet their needs, and provide consistent, predictable and reliable results
Provide program and data analysis and forecasting, developing queries to identify and analyze trends, variances and performance indicators. Provide subject matter expertise and guidance on data interpretation, metrics, and performance measures
Present actionable insights to management and division staff to support business decisions and drive strategic decision making for programs and activities
Identify and resolve data gaps, ensuring reports include required data and support strategic goals. Troubleshoot, resolve issues and ensure data is accurate and provides useful, relevant information
Ensure data integrity and quality assurance for reporting and analysis
Serve as a technical subject matter expert for assigned business intelligence tools, providing guidance on tool use, data interpretation, and reporting functionality
Support systems used in the Single Family team and collaborate with leaders and business partners to optimize performance and implement improvements
Develop, maintain and enhance process and procedure documentation ensuring accurate, detailed and updated timely
Perform other duties as assigned

Qualification

Data reportingSQLBusiness intelligence toolsData management principlesMicrosoft ExcelData quality controlData analysisCultural competencyAnalytical skillsCommunication skills

Required

3 (Three) years of experience in data reporting doing report design and development, including complex query writing and dashboard creation using business intelligence tools (e.g., Excel, Power BI, Tableau, or similar). + A Bachelor's degree in Statistics, Data Science or Analysis, and Information Systems may substitute for 12 months of experience – or – an Associate degree in the listed fields may substitute for 6 months of experience
Experience in SQL and relational databases, data auditing, and ETL (Extract, Transform, Load) processes
Strong knowledge of data management principles, including the ability to clean, standardize, and ensure data accuracy and consistency across multiple systems
Demonstrated ability to effectively use Microsoft Excel, including experience creating and maintaining advanced workbooks, working with VBA (Visual Basic for Applications), and developing tools to extract and aggregate data from multiple source files
Experience implementing data quality control activities and conducting structured data reviews, with strong analytical and problem-solving skills to troubleshoot data issues, resolve discrepancies, and improve reporting processes
Ability to clearly communicate technical information to non-technical users and work collaboratively across teams to align data practices with business goals
Cultural competency as demonstrated by skills for communication and interaction across cultures and awareness of one's own world view and that different world views exist

Preferred

Demonstrated expertise in SQL, including writing and optimizing complex queries across large datasets, along with experience using Python for data analysis and processing
Demonstrated experience using enterprise content management (ECM) tools for document processing and data management tasks
Experience supporting periodic data quality review cycles, including developing documentation and tools, and creating and maintaining data flow diagrams and documentation of data sources and architecture
Prior experience working with internal and external stakeholders to fulfill data requests in compliance with organizational policies and practices
Demonstrated initiative and creativity in designing scalable tools, automating manual data tasks, and improving operational efficiency

Benefits

Paid vacation and sick leave
12 paid holidays each year
Low-cost medical, dental, vision, and prescription drug plans
Fertility care, including IVF
Diabetes care
Dental and orthodontic care for adults and children
6 weeks paid leave for parents of newborn or newly adopted children
Pension plan that provides income when you retire (after working at least three years)
Employer paid life insurance to provide support for your family in the event of death
Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury
Tax-free expense accounts for health, dental, and dependent care
Resources that provide support and promote physical, emotional, social, and financial well-being
Training, classes, and professional development
Student Loan Reimbursement (pilot program)
Tuition Assistance Program
Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov)
Employee Assistance Program (EAP) for work/life support
A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance
Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care

Company

State of Minnesota

company-logo
State of Minnesota provides information for residents, businesses, government, employment, education, and travel.

H1B Sponsorship

State of Minnesota has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Tim Walz
41st Governor of Minnesota
Company data provided by crunchbase