Senior Full Stack Developer
International Federation of Red Cross and Red Crescent Societies - IFRC · Indiana, United States · 1 wk ago
EngineeringOther
Data analytics and reporting
- Analyze and understand business process and data models, business logics, modelling logics, and ways to identify missing data.
- Liaise with business contacts or business analysts to understand their needs, and translate these into specifications of requirements.
- Identify data requirements and data elements and ingest them in the data platform if missing.
- Design and implement complex dashboards and reports in Power BI to provide actionable information.
- Follow through on UAT identified issues and their resolution.
- Publish data and reports to production.
- Maintain dashboards and reports over time.
Data Engineering
- Develop database schemas, define relationships, and optimize performance based on the specific requirements of the data solution.
- Develop data products using SQL and PySpark.
- Implement data quality checks and processes to ensure data accuracy, consistency, and completeness.
- Implement security measures to protect sensitive data and ensure compliance with relevant regulations and standards.
- Optimize solutions for performance and scalability.
- Identify and resolve performance bottlenecks, optimize SQL queries, and fine-tune data processing workflows.
- Document data engineering processes, system architecture, and data flow diagrams for knowledge sharing and future reference.
Team Management
- Oversee the operation of the full stack developers, managing priorities, interactions, and workload.
- Track and document the progress of the team through tools like devops boards.
- Propose improvements to processes and technologies, bringing efficiency to the team.
- Mentor the development of the team, including the development and refinement of skills.
General
- Work collaboratively with cross-functional teams, including architects, data scientists, data analysts, and business stakeholders.
- Act as authority across the organization in area of data engineering and report development, and as a mentor and guidance for colleagues to encourage the adoption of self-service analytics across the organization.
- Provide technical guidance and training to colleagues on data management best practices and Microsoft data technologies.
- Support the Manager of the Data unit with regular progress reports on results against objectives and responsibilities.
- Work in close consultation and develop partnerships with colleagues with data roles across the secretariat in Geneva and in the regions.
Education Required
- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
Experience Required
- 7+ years of progressively responsible experience in data engineering with a focus on data modelling and 4+ years in data engineering (Microsoft Fabric or Azure Synapse) and report development (Power BI).
- Proven track record as a Data Engineer or similar role, and in Power BI development, including Paginated or SSRS reports.
- Core Expertise in the Microsoft Data Stack, in particular proficiency with Fabric, Azure Data Factory, Azure Synapse Analytics.
- Proven experience in Data Lake and Data Lakehouse implementation (e.g., Microsoft Fabric, Azure Synapse, Databricks, Snowflake, Microsoft SQL Server, Apache Spark/Hadoop, or other similar big data or SQL databases).
- Experience in Data Vault and dimensional data modeling techniques.
- Proficiency in programming languages such as Python, SQL, or Java.
- Knowledge of Finance/Accounting logic in ERP, ideally with D365 F&O. Understanding humanitarian accounting logic is a benefit (appeals, pledges, projects, etc.).
- Experience in data governance, architecture, and handling large datasets and data pipelines.
- Strong knowledge of Azure Cloud architecture and networking principles.
- Familiarity with CI/CD pipelines for data workflows (e.g., using Azure DevOps).
- Proven experience in leadership of a data science (or similar) team, with management of direct reports.
- Experience in management and delivery of technical projects.