The role is IT Developer (Data Engineer) for TMF Group and the role will report to the Data Insights Technical Lead.
Primarily role is to ensure timely design and deliver Data Warehouse / ETL Processes and PowerBI Reports dashboards assigned by the development manager in a cost-effective manner.
Data preparation, data quality and master data management with tools like SSIS, DQS, MDS.
The Developer is expected to work within the security standards and code quality requirements of the group including full documentation and use of source control.
Key Responsibilities
Understanding Business requirements and existing ecosystem
Converting Business requirements into technical solution
Design schema for Datawarehouse as per requirements
Design and develop ETL process using SSIS to load data from different source systems in DW
Design schema to manage Master Data and implement Master data services
Design reports in PowerBI and SSRS.
Deliver the reports using Iterative, Agile or Waterfall model as necessary
Liaise with other development, business and systems support teams for clarifications
Participate in Effort Estimation, Work scheduling process with Leads
Provide support and fix issues in existing reports/ETL processes
Identify and test for bugs and bottlenecks in the solution
Ensure good performance and quality of reports/dashboards/ETL processes
Ensure process compliance
Provide Daily / Weekly update on progress of work
Identify areas of improvement and propose solutions
QUALIFICATIONS
Have a passion for data solutions
Has a strong problem solving and analytical mindset
Willing to learn new skills and technologies
Self-starter with self-initiative and direction
Strong interpersonal skills and ability to work in a collaborative environment
Demonstrable track record of dealing well with ambiguity, prioritizing needs, and delivering results in a dynamic environment.
Excellent verbal and written communication skills with the ability to effectively advocate technical solutions to engineering teams and business stakeholders
Candidate profile
4 to 6 years of work experience in Data Warehousing, designing Dimensional models, designing and developing ETL processes, designing reports
Strong understanding of database technologies and management systems.
Strong understanding of developing complex data solutions
Anticipate, identify and solve issues concerning data management to improve data quality
Experience in implementing solutions for Master Data Management
Experienced in extracting, cleaning, transforming and integrating data across heterogenous source systems
Comfortable working with different data formats
Working knowledge of Big Data and Data Lakes
Fluent in relational based systems and writing complex SQL
Experienced in designing reports in SSRS/Power BI
Good working knowledge of SQL Server, SSIS, SSRS, PowerBI Azure
Microsoft certified (preferred)
Experience in working with Business stakeholders, understanding requirements and designing Business Intelligence systems.
Knowledge of implementing Data as a Service (DAAS)
Experience working in an agile and iterative landscape