Job Vacancies at NMG Benefits

SUMMARY STATEMENT

• We’re looking for a curious, intelligent, and proactive cloud focused Senior Data Engineer to help us tackle complex data analytics projects end-to-end in Microsoft Azure. You will work with various teams based in multiple locations globally to deliver solutions on the Azure Cloud using core Azure cloud tools and languages. In addition, you will participate in improving recent implementations. You’re committed to delivering high quality interactions and you’re excited about making a big impact on a small team.

KEY RESPONSIBILITIES

Success in this role will see the following achieved:

Data Architecture

• Participate in deep architectural discussions to build confidence and ensure customer success when building new solutions and migrating existing data applications on the Azure platform.
• Reverse engineer existing database data models, manage and maintain existing and new logical and physical data models.

Data Engineering (Development)

• Collaborate with functional group leaders and engineering team(s) to gather and analyse business and technical data requirement needs and understand how data is collected, analysed & utilised to design and implement the management, monitoring, security, and privacy of data using the full stack of Azure data services.
• Design and build Microsoft Azure functions to optimize data extractions and ensure data validation, cleansing and merging forms a critical part of data processing solutions.
• Ensure that data services securely and seamlessly integrate with other data platform technologies or application services such as Azure Cognitive Services, Azure Search, or even bots.

Testing

• Perform unit, integration, or system testing (automated or otherwise) on all developed code and / or system components through stringent routines and procedures to ensure accuracy and solution integrity and that solutions run smoothly with optimum operational efficiency, ensuring all solutions will meet SLAs & performance criteria.
• Provide feedback on solutions’ usability, features, and design based on results of testing.

Production Support and Maintenance:

• Provide exceptional support by applying critical thinking skills to troubleshoot, determine the cause of failure, and quickly restore failed components or processes when they occur; Diagnose and remediate resource contention issues and failures in application logs.
• Participate in an on-call rotation with the team, when necessary, specifically related to customer-facing digital cloud solutions.

Training and Mentorship:

• Provide technical training and mentoring to other teams and team members and organize and execute training sessions for the user base of in-house developments for new workflows, procedure recommendations, the availability of data in operational data stores as well as the data warehouse and how to consume the data effectively in business intelligence and analytics tools withing the organization.

YOUR EXPERIENCE

The successful candidate for this role will be able to demonstrate:

• Data Factory, Functions, Resource Manager Templates, Storage Accounts, Notifications Hub, Key Vault, DevOps, Data Lake Stores, Data Lake Analytics, Synapse Analytics, Databricks, HD Insight, SSAS, SQL Database or similar cloud infrastructure (5+ years’ experience and deep expertise in data engineering as applied to Azure preferred), including Visual Studio as applied to SSAS development.
• In-depth knowledge of standard concepts, practices and procedures related to database modelling (logical and physical) and management, concepts of data lakes, data warehousing and data marts as well as legacy migrations to cloud services.
• Infrastructure automation for continuous integration and continuous deployment of technical solutions leveraging Azure Services and Features.
• Hands-on experience in scripting languages such as Python, R, etc.
• Modern version control Git, SVN, TFS, etc.

ADVANTAGEOUS EXPERIENCE

• Advanced Business Intelligence experience, understanding of BI areas and reporting using SQL, SSAS, Tabular Models and Power BI, including proactive identification of issues and coordination of resolutions.
• Applicable Azure certifications including for example Implementing an Azure Data Solution, Designing an Azure Data Solution, Designing and Implementing Microsoft DevOps Solutions.
• Familiarity with the Technology stack available in the industry for data management, data ingestion, capture, processing, and curation as well as metadata management: data governance, data quality, master data management, lineage, data cataloguing, etc.
• Being able to conceptualize the full project life cycle.
• QA testing

go to method of application »

SUMMARY STATEMENT

• We’re looking for talented business intelligence developer to spearhead Analysis Services and Power BI design and development, and surface internal & client-facing dashboards and reports. In addition, you will be enabled to improve on our existing business intelligence models, development processes, standards, and documentation. You’re committed to delivering high quality output and you’re excited about making a big impact on a small, diverse global team.
• In this role, you should have a background in data and business analysis and wide knowledge of BI, warehousing, data integration, data modelling and presentation concepts. You should be analytical and an excellent communicator. If you also have a strong business acumen and problem-solving aptitude, we’d like to meet you.

KEY RESPONSIBILITIES

Success in this role will see the following achieved:

Business Intelligence Architecture

• Participate in the creation and maintenance of our business intelligence architecture and assist in discussions to build confidence and ensure customer success.
• Analyse existing operational standards, processes, and / or governance to identify and implement improvements.

Engineering (Development)

• Understand and effectively discuss business and / or data requirements to set functional and technical specifications for solutions and ultimately design and develop models, dashboards, and reports addressing the business or client needs.
• Identify key performance indicators with clear objectives and consistently monitor.
• Develop and execute SQL queries and conduct data analyses and reconciliations.
• Quickly shape data into reporting and analytical solutions to fast-track requirements clarification and solutioning.
• Align data warehouse development to ensure minimal maintenance and sustainability of business intelligence solutions.
• Create and maintain best-practice and versatile yet integrated tabular or multidimensional Analysis Services models that act as semantic layer for business and client dashboards and reports.
• Perform DAX or MDX queries and functions.
• Developing visually appealing strategic and operational KPI scorecards, dashboards, and interactive reports using Power BI desktop with the ability to drill down data to visualize it in the best possible ways to aid insightful analyses and / or decision-making.
• Implement row-level security on data along with an understanding of application security layer models in Power BI.
• Conduct user acceptance testing and troubleshooting.
• Collaborate with teams to integrate similar data and solutions.
• Perform performance analyses for continuous improvement.
• Respect and work within the boundaries of data governance.

Production Support and Maintenance

• Manage and administer all aspects of the businesses intelligence environment, including provisioning, configuration, performance monitoring, policy governance, security, and access control.
• Ensure all infrastructure components meet proper performance and capacity standards.
• Provide continuous support to resolve issues and to redefine and make technical or strategic changes to enhance existing solutions.

Other Critical Deliverables:

• Training and Mentorship: Provide technical training and mentoring to other teams and team members and organize and execute training sessions.
• Documentation: Originate and maintain documentation and Azure DevOps wikis for new and existing solutions throughout the solutioning life cycle - covering all applicable functional areas, such as bugs, change requests, operational policies and procedures, solution designs, models, technical specifications, test plans and test results, security administration, and user guides.
• Our values: Living the NMG values of Collaboration, Curiosity, Go for It, and Make it Count in all that you do.

YOUR EXPERIENCE

The successful candidate for this role will be able to demonstrate:

• A relevant bachelor’s or master’s degree and Microsoft Power BI certifications.
• Certifications from leading platforms like Udemy, Coursera, Pluralsight or edX.
• Over 5 years’ experience in related roles with the expectation that you have sound knowledge of database management, SQL querying, data modelling, data warehousing, business intelligence, andOLAP.
• Sound knowledge of, and over 5 years’ experience in the Microsoft BI stack, specifically Power BI, Power BI Embedded, Power Query, Power Pivot, Analysis Services, DAX & MDX and an expert in using advanced-level calculations.
• Effective software development life cycle management skills.
• Proficiency in CSS, Java, JavaScript, or Python will be advantageous.
• Knowledge of UI / UX development will be advantageous.
• Insurance and Asset Management industry experience will be advantageous.

NON-TECHNICAL SKILLS

• Ability to interact with business as well as technical teams
• Strong communication and client management skills
• Ability to learn and respond quickly to the fast-changing business environment
• Ability to multitask and excellent interpersonal skills
• Document process, models, designs, and solutions and able to explain, represent, and discuss with stakeholders & teams
• Apply learned lessons into future solution considerations
• Analytical mindset with a problem-solving approach
• Ability to work in an agile environment with a focus on continuous improvement
• Self-motivated and eager to learn
• A team player and able to take initiative, lead and initiate