BI Data Analyst

Remitly•Dayton, OH

1d•$104,900 - $174,700•Hybrid

About The Position

The BI Data Analyst position works closely with Operations Program Management in supporting multiple initiatives to deliver business and technical analysis and metrics driving actionable insights and underlining strategic targets. Heavy focus on independent data analysis, proactive problem solving, and dashboard development with a business partner and solutions-oriented mindset. Ideal candidate can be remote or hybrid from our Dayton, OH, Boca Raton, FL or Alpharetta, GA offices for onsite meetings as needed.

Requirements

Data collection: data cleansing, setting up measurement systems and relational databases, sql queries joining and transforming complex data into an analysis-ready dataset.
Data Exploration: Hands on experience in exploratory data analysis to identify patterns/trends and identify data anomalies/outliers
Data Visualization: Presents actionable insights in a simple story. Effective visualization representation of story (emotion/connection). Advanced knowledge of visualization tools especially Microsoft Power BI and Tableau
Programming Experience in programming languages such as R, Python and Excel Macros, with good understanding on the landscape of the most commonly used data science libraries and packages.
Strong communicator: able to communicate complex, detailed technical/analytical data via enhanced verbal and written communication skills including to non-technical/analytical audience/Senior Management team/Stakeholder level as required
Demonstrated advanced analytical and problem-solving skills in dealing with large complex data sets and projects. Excels in conceptual thinking and proactively making recommendations for solution options.
Advanced computer skills in PowerBI, SQL, and Excel and significant experience with applications within MS Office.
Results-oriented, strong organizational skills consistently demonstrating the ability to independently prioritize concurrent initiatives.
Strong problem-solving and collaboration capabilities, with a business partner/customer service mindset and consistent professionalism.
Independently and effectively navigates a highly matrixed organization, interacting and effectively influencing peers and various management levels.

Nice To Haves

Working knowledge on ETL tools such as Knime or Alteryx will be an added advantage

Responsibilities

Data Infrastructure: Understand complex and underlying data relationships.
Proactively pull ideas, issues, and observations into clear and concise PowerBI dashboards with clear storylines that drive actionable insights and takeaways
Understand how to build relationships for multiple data sets and build and design data models and views within SQL
Develop understanding of internal tool opportunities to improve sourcing, manipulation and delivery of data
Build Dashboards & Reports: Build dashboards that are user-friendly, scalable across multiple teams and provide drill down capabilities
Develop and manage automated routines for data and report deliveries as per agreed mode of communication and timing
Provide consultative services with building quick, stand-alone solutions and prototypes
Translate, where applicable, stand-alone solutions into scalable dashboards / models in line with the BI strategy
Build data models or repositories to manipulate data into a usable structured format
Work with current tools and reporting teams to improve raw data usability
Ensure Compliance: Undertake analysis using range of statistical modelling techniques
Provide business stakeholders with relevant analysis and support them throughout the decision-making process
Once anomalies are identified, use root cause analysis tools and techniques to identify cause and then assign owners for improvement investigation/action
Communicate and collaborate with stakeholders to ensure correct action taken to address anomalies ensuring issue resolution completed and effect confirmation tracked
Independently analyze data and dashboards, question inconsistencies, identify positive and negative trends, gaps, and areas of opportunity, and recommend cost-effective solutions and/or follow-ups. Appropriately challenge the status quo.
Data Visualization: Ensure data collected and reported are accurate and correct in all aspects and meet data compliance standards.
Ensure all technical solutions that are made available are tested and works to expected functionality.
Participate and support data compliance exercises
Create (wherever applicable) and maintain documentation related to data infrastructure, dashboards, and reports
Maintain change log of all changes and revisions that are made
Interact and develop relationships with teams within and outside Operations with the purpose of understanding the data needs
Cross pollinate best practices across the organization
Ad-hoc projects, analytics, and reporting as needed.