Senior Data Engineer
FINCA Impact Finance , Pakistan
Job Description
Role Purpose
Senior Data Engineer takes an active part in development and support tasks related to Enterprise Data Warehouse (EDW), Data Lake, and BI/analytical solutions, which integrate data from 20 countries and provide support for decision-making. Being a member of EDW Development Team, Senior Data Engineer will participate in designing and deploying databases, stored procedures, complex queries and SSIS / automation jobs, developing and maintaining systems to store, organize, and access data, responsible for development of stored procedures, triggers and ETL scripts, responsible for development of reports within the SSRS and Power BI Environments and perform T-SQL code reviews during key points of the SDLC and enforce compliance with T-SQL coding standards.
How is their success measured?
Combination of qualitative and quantitative metrics to measure efficiency and productivity of Enterprise Data Team Engineers.
- Customer satisfaction: Feedback from internal customers / beneficiaries.
- Quality of code:Reliability, performance efficiency, security and maintainability of the code developed by engineer.
- QA Kickback Rate: the number of incidents / issues reported by Quality Assurance team.
Accountabilities
- The Senior Data Engineer will be responsible for designing, developing, and implementing database systems, tools and applications using the Microsoft SQL Server platform.
- Development and support tasks related to different components of Enterprise Data Warehouse
- Development and support tasks related to different components of Data Lake (AWS)
- Development and support tasks related to different ETL / data ingestion components
- Development and support tasks related to BI, analytics and reports
Job Specification
Qualifications
- Proven ability to provide solutions to complex technical problems in a creative and analytic manner
- Should be proactive and responsible; able to work without constant supervision.
- Proven success as a team player having extensive experience in a team-oriented environment
- Ability to work and communicate in a multi-culture, diverse environment
Experience
- 3+ years of proven practical experience as Data Warehouse Developer, as well as solid knowledge of Data Warehousing and ETL concepts
- 3+ years of experience and solid knowledge of MS SQL Server
- Solid knowledge of TSQL language; skills to write efficient TSQL code
- Experience in performance tuning on SQL query / execution plan / data model level
- Experience with SSIS or any other ETL tool
- Experience with Power BI, SSRS or any other BI/reporting tool
- Experience with the following technologies is considered a plus
- Amazon Cloud (S3, EC2, Athena, EMR)
- Big Data (Spark, Hive and Hadoop eco-system)
- Any of the following programming languages: Java, Scala, Python, C#
Knowledge and Skills
- Accuracy, attention to detail and awareness of deadlines
- Excellent communication (oral and written) and interpersonal skills.
- Able to write reports, business correspondence, and procedure manuals.
- Able to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
- Track record of working on projects that delivered different types of business and IT outcomes
- Proven record of training, mentoring and providing ongoing support of architecture best practices to all IT stakeholders.
- Able to reach out across the organization and communicate with people at different levels, with diverse needs and agendas; related capabilities include facilitation and teaming skills.
- Proven abilities of technical writing and documentation
Language Skills
- Fluency in English required
- Fluency in Russian a plus.