BI Analytics Developer
Job Description
JOB PURPOSE
The Data Analytics Developer supports business users by developing solutions that provide data for making important business decisions. He / She will collaborate with various business units and business analysts to develop and enhance reporting, dashboard, scorecards, and data warehouse systems.
He / She will translate business requirements into BI reports and visualizations.
JOB CONTEXT
Assist in the Ecobank’s BI Systems transformation.
Translate business requirements into dashboards, reports, and data models.
Create custom end user tools for reports and analyses that support business strategy analysis, initiative performance reporting.
Create dashboards and scorecards templates
Key Responsibilities
Create new reporting data models by working with internal clients, directors, analysts, and developers to deliver high-performance, high-integrity business intelligence reporting
Build and enhance dashboards, reports, data models and score card
Work closely with analysts, product owners, and other stakeholders to understand their information needs and develop technical solutions.
Work with internal constituents to understand business requirements and goals, and help capture content, and features for layout of our reporting environments.
Develop a business intelligence portal / dashboard
Develop ad-hoc and stored-procedure queries to investigate data issues or create new reports structures for business units
Builds reports using Power Bi, SSRS, or Business Objects
Assist in the creation of ETL processes to populate summary data structures and analysis cubes
Use knowledge of tools to create extract analysis from cubed or tabular data
Assist in defining data access methods or processes for data sources upon which all future reporting will be built.
Participate in brainstorming sessions regarding functional requirements, content organization, process flow, report specifications, and technical integration.
Create data models to show key components of source systems and perform profiling of source data
JOB PROFILE
Experience & Qualifications
Bachelor’s degree in Computer Science, MIS, Math or Business Administration and other related experiences
Hands-on Experience with SQL Database (SQL, Oracle, MySQL), SSIS, & other BI is mandatory
Hands-on experience with Microsoft Power BI is mandatory
Intermediate skill level on DAX and M-Language is mandatory
Hand-on experience with any other data visualization tool (aside Microsoft Power BI) is a plus
Knowledge of Data Warehouse technologies
Understands relational database and star schema concepts is mandatory
Experience with Microsoft Excel / PowerPivot / MS SharePoint BI is a plus
Financial industry experience is a plus
Able to quickly grasp both technology and business concepts in an ever-changing environment.
Strong analytical thinking, problem solver, and attention to detail
The ability to understand unique business needs and translate them into technical requirements
Built multi-dimensional reports and understand the commonly used tools
Skills, Capabilities & Direct Attributes
Ability to translate financial schedules into meaningful presentations is critical. Demonstrated skills and ability to handle multiple projects and deadlines
Must be Customer Service oriented.
Must be a results-driven and action oriented individual.
Must be a true Team player.
Must also be self-motivated and able to work independently and autonomously when asked.
Must possess very strong analytical and problem-solving skills.
Must possess strong abilities and interest in analyzing and extracting useful, business related information from large amounts of Customer and pricing data.
