Job Description
As a member of the global data engineering team, reporting to the Data and Analytics Manager, this role has a primary focus on contributing to our enterprise data warehousing and reporting deliverables.
Responsibilities include designing, creating, and maintaining business intelligence assets and reports that drive innovation, client value and business efficiency.
This position will be working across our largest business units and experience with multi-terabyte database systems is required.
Key Responsibilities
The primary tasks, duties, and responsibilities are:
- Maintaining and enhancing reporting and Power BI solutions.
- Producing reporting stored procedures via T-SQL scripting and DAX.
- Data Modelling and Transformation design.
- ELT development.
- Contribute to cloud migration and ensure system uptime for data warehouse products.
- Participate in Agile work planning, testing, and quality assurance.
Qualifications
Technical Skills
- Experienced level knowledge - Business Intelligence/reporting tools including Microsoft SQL, SRSS, SSIS, SSAS, Power BI, Power BI Paginated and DAX.
- Adept at designing and implementing effective data models and Extract, Transform, Load (ETL) processes slowly changing dimensions for transforming and loading data into the data warehouse.
- Understanding of data governance practices, data lineage, and data quality management to ensure accurate, consistent, and reliable data.
- Familiarity with cloud base tooling – Snowflake, And Python/Powershell are advantageous.
Education/Qualifications
- BA/BS degree in Computer Science, Computer Engineering, or related field, or equivalent practical experience.
- Preferred Qualifications include:
- Expertise in parallel processing warehouses (Snowflake/Redshift),
- high-frequency differential ETL processes,
- and Agile development methodology.