Data and Solutions Engineer - #451870

On behalf of our public sector client, Affinity is seeking a Data and Solutions Engineer responsible for enabling and delivering the data platform (e.g., data warehouse) to support the project's analytics use. This includes establishing the end-to-end data for the project's analytics pipeline, including ingesting data from a variety of data sources (e.g., SNOW, Dynatrace, and AzDO) and creating datasets for analytics and reporting purposes.

Responsibilities:

1) Data Ingestion:

- Ingesting relational, structured, semi-structured, and unstructured data from on premise, cloud, external, document, and other data sources.

- Monitoring & developing guidelines for data ingestion streams for the project.

2) Data modelling:

- Designing logical data models.

- Centralizing business rules and logic for the purpose of efficient, accurate, and consistent analytics solution delivery.

- Implementing logic, such as calculations, derivations, table relationships, data cleansing and standardization, data mapping and linking, etc. in a way which minimizes future efforts for changes.

- Data modelling and data ingestion experience with one or more of the following products or systems is an asset: ServiceNow, Azure DevOps, Dynatrace.

- Blending data from multiple sources into a single information context.

3) Data Quality Assurance:

- Ensure data meets entity an attribute quality requirement.

- Ensure data lineage; ensure standardization for common format data elements.

Requirements:

1) Familiarity with reporting and analytics tools.

2) Proven competency with more than one of the following:

- Advanced SQL skills including stored procedures and data transformation.

- Advanced API integration skills (for data ingestion).

- Expertise in Power Query (M) for data cleansing, transformation, and building reusable dataflows.

- Experience designing optimized data models and star schemas for high-performance reporting.

- Ability to implement row-level security and manage workspace permissions in Power BI Service.

- Skilled in developing interactive dashboards & visualizations tailored to executive and operational needs.

- Advanced DAX skills to create complex measures, calculated tables, and dynamic KPIs.

- Familiarity with performance tuning techniques (aggregations, incremental refresh, query folding).

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 12328