Sr. SQL / ETL Consultant

Open Systems Technologies   •  

Southfield, MI

Industry: Professional, Scientific & Technical Services


11 - 15 years

Posted 170 days ago

This job is no longer available.

OST is looking to hire a Sr. SQL / ETL Consultant for our Data Analytics team. Reporting to our Data Analytics Practice Manager, this role supports business process by developing business software solutions for complex and large-scale projects through data modeling, database design, database development, and ETL development. More and more frequently, our customer’s solutions are cloud-based using big data services and architectures. In this role, it is expected that you will be focused on leveraging these architectures to build solutions for our clients. Responsibilities:

  • Passionately develop system to coding standards and quality
  • Work collaboratively with other developers and architects to determine optimal solution architecture, efficiency, maintainability, and scalability.
  • Meet with potential customers, help determine solution, and build an implementation plan.
  • Develop expertise in cloud-based big data solutions.
  • Mentor less experienced team members.
  • Complete projects/tasks on a timely basis, according to commitments made to stakeholders and management.
  • Proactively update stakeholders and maintain open and courteous communications
  • Report project/task status to the appropriate Delivery Lead per the requested schedule.
  • Utilize a software lifecycle methodology.


  • Minimum 10 years of database development (TSQL / PL-SQL) experience
  • Minimum 5 years of experience with ETL tools including Microsoft SSIS, Informatica, etc.
  • Minimum 2 years of experience with reporting and analytic presentation tools and technologies such as Cognos, Business Objects, Excel Pivot Table Service for OLAP, Crystal, etc. Experience with Tableau or Power BI a plus.
  • Proficient in relational and multi-dimensional data design and development techniques including star schema, snowflake schema, and cube design.
  • Exposure to public cloud (Azure and/or AWS) technology and concepts
  • Ability to research and troubleshoot system issues and products
  • History of working independently and leading small technical teams
  • Experience in a client-facing consultant role with the ability to make an impact on our clients’ business – and ours – on a daily basis
  • Track record of balancing multiple priorities simultaneously with the ability to adapt to the changing needs of the business while meeting deadlines
  • Passionate, inquisitive, disciplined, collaborative and enjoyable to work with
  • Ability to effectively prioritize and execute tasks in a fast-paced, ever-changing environment
  • Strong communication skills and impeccable professional character
  • Desire and ability to learn quickly, stay on top of emerging technologies and take professional risks
  • Demonstrated integrity and clearly defined values
  • Positive attitude and commitment to client satisfaction