Intermediate ETL Datastage Developer jobs

An established organization is seeking an experienced Business Intelligence Developer III to support the design, development, and optimization of enterprise reporting, analytics, and data solutions.

This role develops data driven solutions utilizing data intelligence platforms and tools from Microsoft and IBM through collaborative partnerships with internal and external stakeholders. The position adeptly manages development tickets systematically, leveraging analytical rigor and established processes to deliver high quality, timely solutions within a fast-paced environment that introduces new tools and platforms.

As a subject matter expert, the incumbent drives continuous improvement in analytics delivery methods while maintaining excellence in customer service, problem solving, and solution validation to support critical business decision making.

The successful candidate will have strong technical expertise, a passion for data, and the ability to collaborate effectively with business stakeholders and technical teams.

What We Offer

• Competitive compensation package
• Earned Time-Off Program and vacation
• Group Retirement Savings Plan with employer match
• Educational assistance and career development opportunities
• Comprehensive employee benefits
• Employee Assistance Program (EAP)
• Employee discount programs
• Employee recognition and appreciation initiatives
• Supportive and collaborative work environment

Essential Responsibilities

BI Solution Development & Delivery

• Collaborate with business stakeholders to develop analytics solutions using Power BI for new and existing applications, Power BI for innovated solutions, and adapting to emerging BI tools.
• Transform business requirements into effective BI solutions.
• Design, build, and deploy robust BI reporting frameworks and data visualization tools.

Platform & Operations

• Maintain and support data analytics and corporate reporting systems to for optimal performance and reliability.
• Monitor BI platform performance, manage user permissions, and ensure the scalability of the infrastructure.
• Evaluate, improve, and upgrade existing BI systems as needed.

Intake Process and Ticket Management

• Manage development ticket queues with a focus on quality, problem-solving, and efficient delivery.
• Conduct unit testing, troubleshooting, and quality assurance on analytics deliverables.
• Ensure analytics solutions meet organizational standards and deliver high user satisfaction.
• Oversee customer communication, gather and provide feedback, share insights with team.

Database and Data Analysis

• Provide advanced data analysis through database querying with T-SQL or PySpark, ETL, and data pipelines.
• Provide data modeling for analytics to ensure efficient data processing and accessibility.
• Generate strategic insights from data and translate findings into actionable recommendations.
• Develop and update comprehensive technical documentation.

Leadership & Continuous Improvement

• Serve as a subject matter expert, providing technical leadership and mentoring to the analytics team.
• Lead initiatives to improve data architecture, tools, and processes based on industry best practices.
• Evaluate new technologies and recommend improvements to tools, architecture, and processes.
• Support data-driven decision making and key business initiatives through cross-functional collaboration.
• Provide training and documentation to end users to promote a data driven culture and self-service analytics.

Professional Contributions

• Demonstrate workplace professionalism and contribute to team-oriented efforts.
• Adhere to all corporate business policies and procedures.
• Assist with other duties as required.

Qualifications

• Post-secondary education in Information Technology, Computer Science, Data Analytics, or a related field.
• 5-7+ years of experience in Business Intelligence, Data Analytics, or related roles.
• Advanced proficiency in T-SQL and relational databases is required.
• Advanced proficiency in data warehousing concepts, data modeling and ETL processes is required.
• Experience with Power BI (Power BI Services, Desktop, Power Query, DAX, Administration) is required.
• Experience with Microsoft Fabric (Lakehouse, OneLake, Notebooks) or equivalent is required.
• Familiarity with scripting languages like Python, PySpark or R is an asset.
• Experience with Cognos v11.x (Framework Manager, Report Studio, Administration, Motio PI/CI) is an asset.
• Experience with IBM iSeries and DB2 Experience is an asset.
• Fluent in English with proven competencies in verbal and written communication is required.
• Fluent in French with proven competencies in verbal and written communication is an asset.
• Intermediate skill with Microsoft Office (Word/Excel) is required.
• Successful completion of a credit check, criminal background check, education verification, and employment reference checks is required before employment

Pay: $84,000.00-$105,900.00 per year

Benefits:

• Company events
• Life insurance
• On-site parking
• RRSP match
• Tuition reimbursement

Ability to commute/relocate:

• Sherwood Park, AB T8A 3X6: reliably commute or plan to relocate before starting work (preferred)

Application question(s):

• This position requires the completion of a satisfactory criminal background check, education verification, credit check, and reference check. The company will provide and facilitate these checks. Are you comfortable proceeding with this requirement and able to provide the necessary information to complete this step in the hiring process?

Work Location: In person