Find your next opportunity
ThoughtStorm
Why you are seeing this
This is a sponsored placement. The employer paid to show it above search results, so it did not have to rank for your search.
Why it matched your search
- Title matches
Job summary
The role involves designing and implementing enterprise data architectures, data warehouses, and dimensional models. It also requires developing ETL processes and ensuring data quality through profiling and mapping.
Job details
Must-Have / Important Skill Set Data Architecture & Enterprise Architecture – Strong experience in data architecture, architecture assessment/risk assessment, data architecture standards, principles, and transition planning. Data Warehousing & Data Marts – Hands-on experience with Enterprise Data Warehouse (EDW), data marts, data warehouse architecture, and data integration. Data Modeling & Dimensional Modeling – Strong experience with data modeling, Fact & Dimension design, dimensional models, data structures, business rules, and mapping specifications. ETL & Data Integration – Strong hands-on experience developing and testing ETL processes, preferably with SQL Server Integration Services (SSIS). Data Profiling & Data Quality – Experience with detailed data profiling, data validation, data quality, data analysis, and source-to-target data mapping. SQL / Database Technologies – Strong SQL and SQL Server experience, with knowledge of database design/administration and reporting technologies such as SSRS. Data Modeling Tools & Public Sector Experience – Experience with tools such as PowerDesigner, ERWin, Oracle Designer, SQL Developer Data Modeler, or Visio, along with public-sector/government experience and understanding of privacy/information-management requirements. Strong Advantage: Experience with JOIN/JIMS, court/justice data, judicial processes, Public Sector, or related government justice-sector environments. This position is listed remote with Occasion onsite meetings in Edmonton Alberta (3-4 times in a Year & It is a part time contract role for 1 Year with 24 months possible ext)
What you’ll do
The role involves designing and implementing enterprise data architectures, data warehouses, and dimensional models. It also requires developing ETL processes and ensuring data quality through profiling and mapping.
Requirements
Candidates must have strong experience in data and enterprise architecture, SQL Server, and ETL tools like SSIS. Experience in the public sector or justice-sector environments is highly preferred.
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Data Architecture
- Enterprise Architecture
- Data Warehousing
- Dimensional Modeling
- ETL
- SSIS
- Data Profiling
- SQL Server
- SSRS
- PowerDesigner
- ERWin
- Public Sector Experience
- Data Mapping
- Data Quality
- Database Design
- Information Management
Job areas
- Data & Analytics
- Technology
- Government & Public Sector
- Consulting
- Software