Sql Reporting Analyst

Basic Information







Date Published


Job ID


Travel Amount


Description and Requirements

BMC works with 86% of the Forbes Global 50 and customers and partners around the world to create their future. With our history of innovation, industry-leading automation, operations, and service management solutions, combined with unmatched flexibility, we help organizations free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead.
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 You
As 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 people😊

Key Responsibility
Create 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 Experience
4+ 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 organization  
Certification 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, age, national origin, physical or mental disability, history of disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, sexual orientation, veteran status, 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.