Sr. Data Engineer

S&P Global Ratings The Role: Sr. Data Engineer Grade/Level: (relevant for internal applicants only): 10 The Location: Toronto, CA Summary The Ratings Division is looking to hire a Sr. Data Engineer to lead hands on development and provide design pattern insight. S&P Global structured finance value stream technology team in the Ratings Divisions consists of geographically diversified data engineers responsible to develop scalable solutions by working directly with product development team. Our team culture is oriented towards equality in the realm of software engineering irrespective of hierarchy promoting innovation. One should feel empowered to iterate over ideas and experimentation without being afraid of failure. Impact You will enable S&P ratings business to provide best in class end-to-end analytical, commercial and customer experience by building feature rich solutions including big data engineering, analytics, business intelligence and workflow capabilities. What you can expect An unmatched experience in handling huge volumes of data, analytics, visualization, and services over cloud technologies along with appreciation in product development life cycle to convert an idea into revenue generating stream. Responsibilities: Participate in the design, development and implementation of end-to-end BI solutions with Power BI and Databricks Interact with business users and data owners to understand, analyse and design BI solutions based on their requirements Provide end-user support by interacting with end-users and advocating the usage of BI for decision making Develop stored procedures, views and work on optimizing SQL queries and ETL jobs Troubleshoot BI issues related to ETL jobs, data models and BI reports What We’re Looking For: 6+ years of experience in Big Data and Data Engineering Strong knowledge of advanced SQL and data warehousing concepts Have strong programming skills in SQL, Python/PySpark etc Experience in the design and development of data pipelines, ETL/ELT processes Experience in one of the public cloud providers – GCP, Azure, AWS Experience with relational SQL and NoSQL databases, including Postgres and MongoDB Comfortable using Azure DevOps or similar CI/CD tools, Git At least 3+ years of experience working on Data and Advanced Analytics projects At least 2+ years of experience working with Power BI (or) any other enterprise BI reporting platform (Ex. Tableau) At least 2+ years of experience working with Power BI SDK. At least 2+ years of experience working with Databricks platform and creating Visualization Dashboards and reports. A bachelor’s degree (or) higher in business, computer science, (or) other technical fields Proficiency in at least one programming language, Java (or) Python. Strong data analysis, data modelling and SQL skills along with query optimization experience Excellent communication skills with the ability to work in large teams and interact with both technical and business teams Strong analytical and problem-solving skills Good understanding of Enterprise Data Architectures including Data Warehousing, Dimensional Models, Good understanding of Software Engineering principles and best practices Experience working in an environment/team that uses Agile/Scrum methodology Preferred Qualifications (Nice to haves) Any exposure to AI/ML initiatives is an advantage Any exposure to Cloud(AWS, GCP or Azure) based Data services is an advantage About Company Statement: S&P Global delivers essential intelligence that powers decision making. We provide the world’s leading organizations with the right data, connected technologies and expertise they need to move ahead. As part of our team, you’ll help solve complex challenges that equip businesses, governments and individuals with the knowledge to adapt to a changing economic landscape. S&P Global Ratings offers critical insights for credit, risk and sustainable finance solutions that are essential to translating complexity into clarity, so market participants can uncover opportunities. S&P Global has a Securities Disclosure and Trading Policy (“the Policy”) that seeks to mitigate conflicts of interest by monitoring and placing restrictions on personal securities holding and trading. The Policy is designed to promote compliance with global regulations. In some Divisions, pursuant to the Policy’s requirements, candidates at S&P Global may be asked to disclose securities holdings. Some roles may include a trading prohibition and remediation of positions when there is an effective or potential conflict of interest. Employment at S&P Global is contingent upon compliance with the Policy. ----------------------------------------------------------- Equal Opportunity Employer S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment. If you need an accommodation during the application process due to a disability, please send an email to: [email protected] and your request will be forwarded to the appropriate person.  US Candidates Only: The EEO is the Law Poster http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf describes discrimination protections under federal law. ----------------------------------------------------------- 20 - Professional (EEO-2 Job Categories-United States of America), IFTECH202.1 - Middle Professional Tier I (EEO Job Group), SWP Priority – Ratings - (Strategic Workforce Planning) Job ID: 293603 Posted On: 2023-11-10 Location: Toronto, Ontario, Canada