Job Description
Role - Data Analyst/Engineer Location - Minneapolis - hybrid/2-3 days onsite required
The hourly pay rate range for this position is $51.68–$65.34, dependent on qualifications and experience.
Hollstadt offers medical, dental, vision, life insurance, short-term disability, long-term disability, paid sick leave, and retirement benefits to eligible employees.
Position Summary: This position is a part of the Client's Information Systems department. This position will focus on project- prioritized company-wide requests for analyzing data to provide insights and support decision-making, which includes profiling, cleaning, and transforming data; designing and building scalable data models; creating reports and visualizations; working with stakeholders to identify data needs.
An ideal candidate must have experience turning raw data into meaningful insights to help drive business strategies and operations using SQL, Excel, Power BI, Python / PySpark / Synapse Notebooks for data analysis, and visualization tools. Experienced analyst skills like requirements gathering, stakeholder engagement and compliance/security adherence is also a critical part of the position.
Key Responsibilities: - Gather, clean, and analyze data received and use from multiple sources, including vendors, internal databases and external APIs.
- Perform exploratory data analysis (EDA) to identify data schema, primary keys, data types, methods to identify changed record tracking trends, patterns, and anomalies in the data.
- Develop and maintain dashboards and reports using Power BI to visualize key performance indicators (KPIs) and trends in the data.
- Manage stakeholder and requestor engagement through:
- Understanding their data needs and provide tailored analytical solutions.
- Communicating complex data findings in a way that is understandable.
- Facilitating workshops/training to help make the most of analytics tools.
- Ensure compliance with data governance policies and regulations, as well as maintain data security and privacy standards.
Qualifications: - Proficiency in writing complex SQL queries for data extraction and manipulation.
- Proficiency in using SSMS for database management.
- Expertise in using Power BI for data visualization and creating interactive dashboards and reports.
- Knowledge of Python data analysis, scripting, and automation.
- Advanced skills in Excel for data analysis and reporting.
- Familiarity with data warehousing solutions like Azure Synapse Analytics.
- Demonstrated skills in data cleansing, transformation, and preprocessing.
- Experience with Azure Data Studio for data analysis, visualization, and SQL Server management.
- Ability to use Azure Storage Explorer for managing and interacting with Azure Storage accounts, blobs, files, queues, and tables.
- Familiarity with Azure Synapse Analytics for data warehousing and big data processing.
|