SQL Developer/Data Architect
Montreal, QC, Canada
Fujitsu
Our Purpose: make the world more sustainable by building trust in society through innovation.- 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
- Remote position with 5-10% travel requirement
Responsibilities:
- 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.
Qualifications:
- Bachelor of Science degree and/or relevant work experience
- 7+ years of prior experience as a data analyst or architect
- 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
- 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
Fujitsu at a Glance
Fujitsu is a leading information and communication technology (ICT) company, headquartered in Japan, offering a full range of technology products, solutions, and services. Approximately 132,000 Fujitsu people support customers in more than 100 countries. We use our experience and the power of ICT to shape the future of society with our customers.
We are a corporate culture that places great value on the pursuit of new possibilities previously unimagined and brings them to fruition. This has been the foundation of Fujitsu’s success since its inception. In an increasingly competitive world, in which the pace of change continues to accelerate, Fujitsu must strive for continuous innovation. Each and every employee will rise to the challenge of creating new value amid changes in the management environment, technology, society and the marketplace. With a spirit of challenge, we are committed to the continuous creation of new value. Fujitsu wants innovators like you!
At Fujitsu, one of our corporate principles is "We respect human rights." This principle underpins all our corporate and individual activities and guides the actions of every Fujitsu Group member. We embrace diversity and equal opportunity. Qualified applicants will receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, ethnic or national origin, citizenship, political belief, social condition, family, marital or civil status, genetics, disability, age, veteran status, or conviction of an offence that is unrelated to employment. By empowering people, we can unleash our collective strengths to create a better experience for our employees, our customers, and our partners.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture Big Data Business Intelligence Data governance Data management Data quality ETL Informatica NoSQL Oracle PostgreSQL Python R RDBMS SDLC SQL SSIS Statistics Talend
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.