Insight Global is looking for a skilled Data Engineer to work remotely in Canada for a large AAA game employer. You will be working on a data product that is used across seven game titles. This product is on a local SQL Server backend that has an automated ETL and automated PowerBI reporting feeding into it. It utilizes stored procedures to curate fact tables with PowerBI used to visualize these tables. The Data Engineer is helping to establish new stored procedures for calculations and transformations so that when one workflow or status is added, multiple dashboards can be adjusted simultaneously. This is part of the larger data modernization initiative of combining processes together and increasing efficiencies. You will be working out of the data engineer backlog and attending their sprints. You will also collaborate with cross-functional teams, including leadership, architects, analysts, product management, and project management to understand and address data requirements effectively. Being an inquisitive self-starter who is collaborative is very important to success in this role.
Responsibilities:
Design and develop data solutions, data pipelines, and transformational structures to support reporting.
Design and uphold scripts and queries to process data from various sources, constructing queries that populate reporting layers effectively.
Assemble large, complex data sets that meet business requirements.
Optimize and improve data solutions for optimal extraction, transformation, and loading from various data sources using SQL and Python.
Work with the Architecture team to identify, design, and implement internal improvements, such as automating manual processes and optimizing data delivery.
Participate in architecture assessment and roadmap planning and design.
Interface with various groups such as business users, engineering, architecture, infrastructure and project teams.
Participate in system testing, identifying the need for changes and enhancements.
Proactively identify system problems, failures, and areas for improvement.
Communicate ideas clearly, both verbally and through concise documentation, to business analysts and technical resources.
Update project managers and stakeholders on project progress, articulate challenges, and propose solutions.
Track issue resolution, documentation, and troubleshooting guides.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
HR@insightglobal.com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
3+ years of experience in Microsoft SQL, Postgres preferred
3+ years working experience with SQL and Python
3+ years working with GIT
Proficiency in writing advanced and performant SQL queries on local SQL server
Proficiency working with ETLs
Experience in cloud environments especially Snowflake or GCP
Experience with video games or software development industry
Experience in the physical and logical design of database architecture for relational databases, data warehouses and data lakes
Experience with SQL Cloud
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.