Data Engineer / Architect / Modeler (BB-5022D)

Found in: Talent CA

Our Client consultants are family and valuing each other is one of our most important core values. We are looking to grow our team and we are searching for a Data Engineer / Architect / Modeller. You are the type of person who always asks why, or how can we do this. Has interests and experience in the latest and greatest cloud & database technologies, such as AI, BIA, Cloud, BI/DW, DS, DEA, EDA +++. And will work within the CORE Team of solution providers. Day to day activities for this role would include:• Conduct relevant customer interviews to determine key business requirements and objectives.• Build appropriate analytical data models based on outcomes of user interviews.• Analyze and profile data systems to build source to target data mappings.• Build required ETL to populate target designed data warehouse and/or data lake.• Review ETL performance and conducts performance tuning as required on mappings/workflows or SQL.• Administration and support of data integration infrastructure.• 2nd level on-call support of ETL services as requiredDesired Skills and Experience.• University/College degree in Computer Science, Mathematics, Data Science and/or Relevant Degree• 5+ years hands-on development, configuration, scripting and administration experience with Data Integration platforms. (i.e. Informatica PowerCentre, BDM, ICS, IDQ, EDC, Talend, SSIS, etc...).• BI Experience (MicroStrategy, Looker, Tableau, PowerBI and others) considered a nice to have.• Extensive theoretical and practical knowledge of data warehousing principles/concepts and practical development experience in all areas of the data warehousing life cycle• Experience with Data Management, ETL, Cloud Data (AWS), Data Integration.• Knowledge of OLAP-related principles and concepts.• Strong grasp of data modeling techniques and concepts (Normalized/DE normalized, Conceptual/Logical/Physical, Star, Snowflake, Data Vault).• Strong knowledge and experience with relational databases such as Snowflake, SQL Server, Oracle (Advanced knowledge of reading and writing SQL, Performance analysis and tuning).• Knowledge and experience with key Big Data technologies (Hive, Presto, Spark, Kafka, NoSQL databases, Semi-structured data access patterns (Json, Parquet, XML, etc.)).• Strong Python scripting skills.• Excellent communication skills.• Great problem-solving skills.• Leadership and good client management skills. Please send your resume to, d.gutoski@maxsys.caMSTR

calendar_today2 days ago


location_on Toronto, Canada

work MaxSys

I expressly authorise the Terms and Conditions

Similar jobs