Data Analyst II
IDECO
SUMMARY
The Data Analyst II will play a critical role in engaging with stakeholders and technical team members to execute requirement gathering, documentation of data flows, mapping, extraction, transformation, visualizations, and analytical data analysis. You will work closely with cross-functional teams, including IT and business stakeholders to ensure seamless and efficient data flow, report generation, visualizations, and data analysis. You will collaborate with various departments to ensure data accuracy, integrity, and compliance with established data standards. This role will report to the BEST Data Services Senior Manager in our Business Enterprise Systems Technology department.
A successful Data Analyst must take a hands-on approach, ensuring the highest quality solutions are provided to our business stakeholders, with accurate development, documentation, and adherence to deadlines. This role will also work with key stakeholders across the organization to drive enhancements to a successful implementation and ensure all reporting and analytics meets requirements and are deployed and implemented properly.
PRIMARY RESPONSIBILITIES
- Responsible for engaging with multiple teams (both technical and non) to understand reporting and analytical requirements and objectives.
- Responsible for collaborating with business stakeholders to understand their requirements and translate them into reporting specifications.
- Responsible for retrieving and manipulating data from various sources using SQL, ETL tools, and other data extraction methods.
- Responsible for cleansing, transforming, and enriching data to ensure accuracy and consistency for reporting and analysis.
- Develop and maintain data models to support reporting needs, including data cubes and star schemas.
- Create and maintain standardized reports and dashboards using reporting tools such as Power BI and Tableau.
- Design and build data visualizations that effectively convey insights and trends to non-technical stakeholders.
- Conduct ad-hoc analysis to answer specific business questions and provide actional insights.
- Ensure data security and compliance with relevant regulations and internal policies.
- Responsible for ensuring there is alignment with business objectives.
- Working closely with business stakeholders to ensure seamless data migration.
- Effectively communicate project status, issues, and solutions to both technical and non-technical stakeholders.
- Maintain detailed documentation of data migration processes, decisions, and outcomes.
- Provide post migration support.
- Adopt a proactive, hands-on approach to resolve any issues related to these platforms.
- Collaborate with onshore and offshore business and technical teams to assist with creating solutions for complex internal business operations.
- Work closely with business partners to define strategies for technical solutions, determine requirements, and develop high-level designs.
REQUIRED KNOWLEDGE/SKILLS/ABILITIES
- Minimum of 1 years of hands-on Data Analyst experience demonstrating experience with data analysis, reporting, visualizations, and data warehousing techniques.
- Proficient with SQL for data extraction, manipulation, and analysis
- Minimum of 1 years’ experience with data visualization tools (eg. Power BI)
- Minimum of 2 years' experience with utilizing Python libraries for data visualization and analysis.
- Strong understanding of data structures, databases, and data models.
- Strong communication skills
- Proficient in designing and implementing process workflows and data diagrams.
- Proven Agile development experience, you can understand what Epics, Features and Stories are and can define one.
- Excellent problem solver and independent thinker who can create innovative solutions.
- Exceptional communication, analytical, and management skills, with the ability to present technical concepts to both business executives and technical teams.
- Able to manage daily stand-ups, escalations, issues, and risks.
- Self-directed, adaptable, empathetic, flexible, and forward-thinking.
- Strong organizational, interpersonal, and relationship-building skills conducive to collaboration.
- Passionate about technology, digital transformation, and business process reengineering.