Data Architect, Data Governance

Job#: 2065639

Job Description:

Data Architect, Data Governance

Apex Systems is a global IT services provider and our consulting practice has an opening for a Data Architect with strong analytical, communication skills and attention to detail to place at our client, an Enterprise Multinational Retailer.

Client: Multinational Retailer

Terms: Ongoing Contract, 12 month rolling extensions

Location: Remote in Canada, must be able to work PST hours

Application Process: It is best to apply via the medium on which you are seeing this posting. If you encounter technical difficulties submitting your resume, please send a Word version of your resume to Grace Chisholm at [email protected] Please reference: Data Architect, Data Governance Job ID: 2065639

Job Summary:

The Data Architect is responsible for designing the overall data architecture and data modeling strategies for the BI system. They collaborate with stakeholders to understand business requirements and translate them into a robust and scalable data model. Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

Job Responsibilities:

• Data Integration: Data Architect will work on integrating data from various sources, such as databases warehouses and external systems. They develop strategies for data extraction, transformation, and loading (ETL) processes to ensure data accuracy, consistency, and availability for reporting and analysis.
• BI Tool Selection and Implementation: Evaluate and select appropriate BI tools and technologies based on the organizations needs. Run POC and the implementation and configuration of BI software, including data visualization tools, reporting platforms, and analytics solutions.
• Performance Optimization: Monitor and optimize the performance of the BI system to ensure efficient data retrieval, processing, and reporting. They identify and resolve performance bottlenecks by tuning queries, optimizing data structures, and implementing caching mechanisms.
• Collaboration and Stakeholder Management: Data Architect collaborates with business stakeholders, data analysts, developers, and IT teams to understand their requirements and deliver solutions that meet their needs. They communicate complex technical concepts to non-technical stakeholders and provide guidance on leveraging BI capabilities.
• Continuous Improvement: They stay updated with the latest trends, technologies, and best practices in the BI field. They explore opportunities for process improvement, automation, and innovation to enhance the organizations data analytics capabilities.
• Data Governance and Security: Data Architect needs to establish data governance policies and procedures to ensure data quality, consistency, and security. Define access controls, data privacy measures, and data retention policies to comply with regulatory requirements and protect sensitive information.
• Lead, design and implement innovative analytical solution using Tableau, SQL, and other Big Data related technologies
• Work with product and engineering team to understand requirements, evaluate new features and architecture to help drive decisions
• Build collaborative partnerships with architects, technical leads and key individuals within other functional groups
• Perform detailed analysis of business problems and technical environments and use this in designing quality technical solution
• Actively participate in code review and test solutions to ensure it meets best practice specifications
• Build and foster a high-performance engineering culture, mentor team members and provide team with the tools and motivation to make things happen
• Work with stakeholders and cross-functional teams to develop new solutions or enhance existing solution
  
  

Must Have Requirements:

• 8-10 years of software development and deployment experience with at least 5 years of hands-on experience with SQL, Databricks, ADF, Datastage (or other ETL tool), SSAS cubes, Cognos, Tableau, Thoughtspot and other BI tools
• Write SQL for processing raw data, Kafka ingestions, ADF pipelines, data validation and QA
• Knowledge working with APIs to collect or ingest data
• Experience with Scala and Python
• Strong Database knowledge, SQL & No-SQL preferred
  
  

Other Requirements:

• Experience building data ingestion pipelines (simulating Extract, Transform, Load workload), data warehouse?or database architecture
• Experience writing design documentation, Source to Target mapping documentation, manage confluence pages.
• Experience in converting business functionalities into technical jira stories
• Experience in analyzing huge datasets, identify trends, patterns, and outliers to extract meaningful insights
• Strong experience with data modeling, design patterns, building highly scalable Business Intelligence Solutions and distributed applications
• Knowledge of cloud platforms, for example:
• Experience with Azure, AWS or equivalent cloud platforms
• Experience with storing, joining, filtering, and analyzing data using SQL, Spark, Hive etc.
• Experience working with continuous integration framework, building regression-able code within data world using GitHub, Jenkins and related applications
• Experience with programming/scripting languages such as Scala/Java/Python/R etc. (any combination)
• Analytical approach to problem-solving with an ability to work at an abstract level and gain consensus; excellent interpersonal, leadership and communication
• Data-oriented personality. Motivated, independent, efficient and able to handle several projects; work under pressure with a solid sense for setting priorities
• Ability to work in a fast-paced (startup like) agile development environment
• Friendly, articulate, and interested in working in a fun, small team environment
  
  

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6 months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Apex team member can provide.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6 months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Apex team member can provide.

4400 Cox Road

Suite 200

Glen Allen, Virginia 23060

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] (Do not submit resumes or solicit consultants to this email address). UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Apex Systems.