The IT Technical Specialist (Data Architecture and Data Engineering) has key responsibilities to work with technical team members to plan and configure changes, resolve complex technical problems, design solutions and ensure reliable operation of information services and products. As an IT Technical Specialist, you play an essential role to ensure that deliverables meet both technical requirements and business needs. You create blueprints that ETL Developers and Data Engineers follow. Continuing professional development is your norm, and you keep up to date on information application technology and trends. You use effective communication and listening skills and know which audiences to use tech-speak or business language. This position is located in Calgary; Edmonton location and remote/hybrid will be considered.
The IT Technical Specialist is an expert in the data architecture and engineering area, has deep knowledge of data management, software engineering, and infrastructure and operations related to data warehousing, business intelligence, and analytics. The IT Technical Specialist works collaboratively with team members, IT colleagues, business clients and collaborators to manage diverse projects and operations. The successful candidate must balance work simultaneously on multiple projects and operational activities with changing priorities, make decisions and give clear and concise advice and recommendations. Job responsibilities: Modeling and designing data structures (data modeling), storage, and integration solutions. Leading database analysis, design, and build efforts while coaching and mentoring team members. Ensuring that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth. Monitoring system performance by designing and implementing system health monitoring, performing regular tests, troubleshooting, and integrating new features. Recommending solutions to improve new and existing database systems. Educating staff members through training and individual support. Offering support and responding to system problems in a timely manner. Managing relationships with team members, peer IT groups, business clients and software vendor support.
Required Qualifications:
Completion of bachelor’s degree in Computer Science or Information Technology or equivalent. Five years applying progressive knowledge and skill in data engineering, data integration, data warehousing, repositories, business intelligence and analytics; up to date with industry best practices, trends, tools, and methodologies. Experience with leading small teams of developers and administrators, coaching, mentoring and coordinating operations. Proven background of designing and implementing architectural solutions.
Additional Required Qualifications:
Technical skills: Strong technical understanding and hands on experience with relational and dimensional data modeling and architecture principles. Highly competent with structured query language (SQL) and T-SQL or PL/SQL. Deep knowledge of best practices through relevant experience across data-related disciplines and technologies, particularly for enterprise-wide data architectures, data management, data governance and data warehousing. Creating, tunning and operating ETLs/ELTs to handle data extraction from various data sources (in cloud and on-premises) and various formats. Strong Data Warehousing and Business Intelligence skills including scalability issues for enterprise level data warehouse. Proficient with data integration tools and languages such as Informatica PowerCenter, SSIS, and Python. Able to work in Linux, Windows, and cloud environments. Analytical skills – experience performing system, process, and data analysis; expert analysis of complex systems for problem solving/debugging technical, process or data failures/issues. Communication skills – well developed verbal and written communication skills; proven ability to interact in a team environment; able to write technical documentation and draw models and workflows; able to articulate issues and solutions and adjust tech-speak for audiences; routinely engages and collaborates to achieve consensus; and coordinates work of multiple developers and IT teams to achieve desired outcomes.
Preferred Qualifications:
A strong team player with conflict resolution and problem-solving skills. Actively builds and maintains positive relationships. Ability to work with business areas to understand business requirements and develop solutions. Strong technical background in Data Engineering (Data Management, Software engineering and Infrastructure and operations). Self-motivated, focused, independent and productive.
Merkur, une firme d’experts en performance manufacturière depuis 1994, vous offre une belle opportunité de contribuer à son développement. Nous...
Apply For This JobLaughing Dragon Studios is looking for a talented and versatile UX/UI Designer to create exceptional digital experiences that seamlessly blend...
Apply For This JobARE YOU PASSIONATE ABOUT ARTIFICIAL INTELLIGENCE? If you are looking to complement a stellar career we are ready for YOU!...
Apply For This JobPOSTE RÉGULIER À TEMPS PLEIN (35h00 heures) Traitement horaire De 24,21 À 32,32 $ selon scolarité et expérience. Horaire régulier...
Apply For This JobSenior Backend Developer Job Description Overview : 1. CodeBoxx serves customers and partners in multiple markets and across multiple technologies....
Apply For This JobAbout Cert Centre Canada Cert Center Canada is an independent flight test, research, development and certification center providing a wide...
Apply For This Job