Sr Data Warehouse Engineer

• Data Intelligence & Analysis :

• Study and understand the company s business processes and applications, including their effect on data and reporting, and apply the knowledge gained in designing data warehouse objects and reports.

• Building reports, adding new fields, creating Business Objects filters, measures, and other solutions . Leveraging MS SQL Server and PowerBI .

• Dimensional modeling for new solutions that meet the business needs .

• Creating dashboard proof-of-concepts that elevate data and business intelligence using either PowerBI or Excel.

• Collaboration:

• Driving the technical requirement gathering process by working with stakeholders.

• A ssist data warehouse users with leveraging the various solutions available .

• Working with peers to find the right solution to any data challenge.

• Occasionally responsible for:

• Supporting ETL processes that involves error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS).

• Performs capacity planning, supporting, troubleshooting, and ETL /procedure performance modification.

Skills & abilities this individual should possess :

• B.A./B.S. in Computer Science or related field.
• 8 + years of experience working with relational databases in a business intelligence capacity .
• 5+ years with traditional Data Warehouse, data modelling / data mart development.
• Strong SQL skills, T-SQL preferred .
• PowerBI e xperience , particularly building data visualizations to describe business constructs .
• Technical writing skill s, supporting both engineering and user facing documentation .
• Data analysis skills with a proven ability to identify business trends and insights as well as data inconsistencies and patterns.
• Proficiency with Git Hub , JIRA , and Change Management.
• Experience with SnapLogic or other integration tools a plus.
• Strong ability to collaborate and build effective relationships with your colleagues