LeverageTek Staffing Solutions
LeverageTek is actively seeking a SQL Developer/Data Architect for a 6-month contract with its Ottawa-based customer. Work Location Remote position with 5-10% travel requirement to Montreal. Key Tasks Define and document data ETL procedures, standards, and metrics to support customer analytics business rules. Establish data quality processes and compliance with data standards for data domains. Troubleshoot issues with data quality as identified by stakeholders. Perform activities to address data extraction, data validation, data cleansings, data harmonization, business logic, exception handling, and required data indication. Design and build a data inventory including field definitions, ontologies, list of values (LOVs), and mappings as requested by the stakeholder and defined by requirements. Understand critical data relationships and customer data domains. Collaborate with business process owners, data producers, and data consumers to get an understanding of current processes and systems that has a direct impact on the quality of the enterprise data. Work with business application engineers to define and maintain a customer data model and Analytics solutions. Key Qualifications Experience with defining and documenting data ETL procedures, standards, and metrics to support customer analytics business rules. Experience establishing data quality processes and compliance with data standards for data domains. Experience performing activities to address data extraction, data validation, data cleansings, data harmonization, business logic, exception handling, and required data indication. Experience designing and building a data inventory including field definitions, ontologies, list of values (LOVs), and mappings as requested by the stakeholder and defined by requirements. Qualifications Strong experience working with retail Point-of-Sale (POS) Transaction Log (TLOG) files and mapping data to be used by other retail related business applications Bachelor of Science degree and/or relevant work experience 7 years of prior experience as a data analyst or architect Data Architect deep understanding of ETL Tools, Best Practice Processes (Enterprise ETL Tools, Self-Service, Data Preparation)- Data Movement Tools (SSIS, Informatica, Talend, etc.) Proficient in SQL (SQL, Stored Procedures, Dynamic SQL, Joins, Aggregation, etc.) Experience with Data Structure Solutions (Big Data, RDBMS, NoSQL) Experience with a couple of Database Systems (Oracle, SQL Server, My SQL, Postgres, etc.) Skilled in one scripting language, such as R, Python, VBScript, Shell Script Understanding of Data Governance, Data Integrity, Master Data Management, Data Quality Design, Develop, and Deployment Best Practices Experience structuring and analyzing large quantities of data and information for statistical and analytical modeling Understanding of Business Intelligence Best Practices, Architectures, Tools, Methodologies, and Software- Good Strong oral, written communication and leadership skills Proven ability to partner with client stakeholders from various parts of an organization Ability to handle multiple tasks and workstreams in a fast-paced environment Experience with SDLC methodologies (Agile and Waterfall Development) Experience with Data Modeling About LeverageTek Staffing Solutions Thank you for taking the time to apply Since our company’s inception in March 2003, LeverageTek Staffing Solutions has worked to become a trusted partner with our consultants and customers. LeverageTek provides end-to-end, cross-functional staffing solutions throughout North America. With thousands of successful engagements to our credit with leading public and private sector organizations, we are the experts in identifying, deploying, and supporting IT and business talent on a contract, contract-to-hire, and permanent basis. Our responsive service and ability to deliver the right fit, on time and within budget, often leads to repeat engagements and a long-standing relationship. Accessibility accommodations are available upon request
Source ⇲
