Vacancy expired!
- Engage with business Analyst to understand requirements and needs and translate that into Analytical reports and dashboards
- Functions as the lead for BI-SDLC (Business Intelligence Software Delivery Lifecycle) projects.
- Collaborates and work closely with Business, System Integration and Cloud data architects, ETL (Extract, Transform, Load) Integration specialists and Power BI dashboard development team.
- Analyzes and translate business requirements into technical requirements.
- Develops BRD and/or TDD independently.
- Designs and develops data models and applies best practices for optimum performance of the models.
- Documents project specific processes and data flows, data dependencies, data definitions and relevant business rules.
- Establishes data dictionaries to support the buildout of a data governance infrastructure.
- Converts functional requirements into technical specifications.
- Performs data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
- Designs and develops DDL scripts, ad hoc queries and data models for high performance projects and deliverables.
- Bachelor's degree from an accredited university or college, preferably in a job related major field of study
- Minimum five (5) years of relevant professional experience, or equivalent combination of education and experience
- 3+ years of hands-on experience with R, Python, MML, SAS Enterprise Miner or similar tools in support of on-demand, real-time analytic services.
- Experience with warehouse data extraction/transformation and load tools, as well as metadata repository tools.
- Advanced proficiency in relational Database concepts, Database design using star, snowflake and data vault schema along with ability to write and execute complex SQL queries and stored procedures.
- Knowledge of various database platforms (DB2, SAP,MS SQL Server) required and experience with one or more of the following, Power BI, Informatica, Azure Cloud, IoT, MuleSoft, AQT, ErWin Data Modeling.
- Proficient with MS Office tools like PowerPoint, MS Project, Visio, Excel and Word and shell scripting.
- Understands and evaluates existing SQL scripts and Data Models.
- Experience with the SDLC and ETL Processes, data mining, database design development, data modelling, data governance and unit testing.
- Proficient in data transformation, consolidating data from multiple disparate sources, develop process workflows and wireframe sketches to help business design effective dashboard solutions.
Vacancy expired!