Senior ETL and Database Analyst

Job Description

Description and Requirements #LI-BL1From core to cloud to edge, BMC delivers the software and services that enable over 10,000 global customers, including 84% of the Forbes Global 100, to thrive in their ongoing evolution to an Autonomous Digital Enterprise.About the Team-We are the One BMC Operations Analytics team, a highly functional, growing, business & outcome-focused agile team that enables business groups and departments within BMC. Through our data (lots of it!) analysis, our insights, our insight bots, and applications/tools, we empower our users to self-serve their data/insight needs now and in the future.About YouAs a Sr. ETL and Database Analyst, you will support Marketing Data Repository to maintain and share the most accurate data with business and analytics users. You will also work closely with business and analytics to understand and solve the business problem. You will be responsible for optimizing, updating, and maintaining a multidimensional database model.You are a data-literate individual, passionate about data, analytics and keen to support businesses to make data-driven decisions. You re a team player and believe in building synergies across BMC to create/continually evolve one integrated customer journey. Continuous learning is your mojo. You know how to have fun and connect with peopleKey ResponsibilityCreate new database objects that answer a business question.Transform existing/new data sources using ETL/Script.Automate data processes to shorten the data-to-insight creation process.Create new/update existing dimension model to support reporting needs.Work collaboratively with sales, marketing, customer success, and product to enable a one integrated customer journey analytics platform.Professional Experience4+ years of experience in database management, dimensional modeling, ETL (Extract-Transform-Load), performance optimization, managing/building DataMart, etc.4+ years of experience in marketing/sales data and analytics with the ability to connect business requirements with data.4+ years of experience working with databases (SSMS, Snowflake, Redshift, Oracle, or any other database, etc.)1+ year Agile experience in database design and delivery.Well versed in designing new database objects which are optimized and scalable from a performance perspective.Extensive experience in SQL, ETL, Database Modeling, understanding Databases Design, Functionality, etc.Experience in ETL tools like Informatica, SSIS, etc, and visualization tools like Tableau, Qlik, PowerBI, etc.Strong knowledge of Data warehousing and BI concepts, dimensional modeling, SCD, CDC, design methods, etc.Experience in Graphs database or Azure, Data Science and/or Machine Learning and data engineering will be an added advantage.Ability to express complex concepts in simple terms at all levels of the organizationCertification in Data Warehousing and Business Intelligence, etc. will be an added advantage.Bachelor s Degree in a Computer Field (Computer Science, Information Technology, Engineering, etc.) OR any relevant field.It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, creed, sex, age, sexual orientation, national origin, disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, disabled veteran or status as a protected veteran, genetic information or other factors prohibited by law, and to prohibit harassment or retaliation based on any of these factors. If you need a reasonable accommodation for any part of the application and hiring process, visit the accommodation request page .,

Keyskills :
databasessql serversqldatabase management