Covenant Technology Partners

Senior Data Analytics Consultant


Covenant Technology Partners is seeking a Senior Data Analytics Consultant to join our Data Analytics Practice in St. Louis, MO. As a Microsoft Gold Certified Partner, you will be leveraging the Microsoft BI Stack of tools (SSIS, SSAS, SSRS, PowerBI, PowerPivot, etc.). You will be working as part of a team to implement a reporting environment customized to meet the specific needs of the client. In this role you will collaborate with internal and external client stakeholders and data engineers over variable length client engagements, performed as a combination of remote and on-premise work as needed.
The Data Analytics Consultant has the following responsibilities:

  • Passion for working collaboratively in a team environment to deliver world-class client solutions.

  • Works with users and developers to understand their data needs and relationships to existing corporate data.

  • Build data visualizations using PowerBI.

  • Create custom SSRS, Excel, and PowerPivot reports.

  • Data modeling – Creating the logical and physical data model and modifying the model on an as-need basis. This usually means working closely with the data analyst and business analysts.

  • Create Multidimensional/Tabular models in SQL Server Analysis Services to aggregate data based on dimension hierarchies.

  • Build Facts and dimensions – Create a data mart, data lake, or data warehouse design as per requirements. This includes building fact and dimension tables in SQL Server and linking them with the appropriate keys.

  • Creating SSIS packages on SQL Server – The Developer must create processes to extract, transform and load data.

  • Remain current on Business Intelligence industry issues, emergent technologies, standards, and market trends.


Position Requirements

  • Bachelor’s degree in Information Systems or Business Administration, or equivalent experience required

  • 5+ years progressively responsible experience in enterprise application implementation

  • 3+ years building custom reporting solutions using Microsoft Business Intelligence Technologies.

  • Microsoft PowerBI workspace and services

  • Microsoft Excel, PowerPivot

  • Microsoft SQL Server Reporting Services

  • Microsoft SQL Server Analysis Services

  • Microsoft SQL Server Integration Services

  • Azure Cloud

  • Strong working knowledge of SQL Server (relational database concepts and business intelligence)

  • Overall business knowledge on business systems, processes and business practices.

  • Ability to express complex technical concepts effectively, both verbally and in writing

  • Strong communication skills, both oral and written with strong analytical and problem-solving skills

  • Able to take initiative in fast paced work environment and able to interface with all functions at all levels within the organization

  • Strong Quality and Customer Satisfaction Orientation.

  • Ability to juggle multiple complex priorities within a changing environment

  • Other duties as assigned.


Why Join Us

Covenant is a great place to work where every project matters.
Our culture is one of excellence, innovation, empowerment, and caring about our customers, communities, and employees.  At Covenant, we have great employees and know that they are critical to the company’s success. 
The Core Values we live by to achieve our success are:

  • Partnering with integrity

  • Selfless dedication to team success

  • Commitment to work life balance/family

  • Unrelenting pursuit to individual excellence

  • Innovation through our passion for technology

  • Technology community leadership

  • Commitment to community service

We are looking to add strong candidates that uphold Covenant’s Core Values and are creative and passionate about cutting edge technologies and helping clients succeed. If you share these values and enjoy a work environment that is fast paced, hands on, and results oriented, then Covenant Technology Partners is the place for you.

Covenant Technology Partners is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, or national origin or any other characteristic protected under federal, state, or applicable local law