SQL/BI Engineer

Manifest Solutions - Columbus, OH

Manifest Solutions is currently seeking a SQL/BI Developer for a remote position based in OH.

  • Work with data analysts to identify manual download, data preparation tasks and create equivalent SQL queries to streamline the process.
  • Identify fact and dimension data not present in the Data Warehouse needed to deliver on reporting requirements and drive updates to the ETL process to include the new data.
  • Design SQL queries with the intention of creating Views from the queries for the purpose of streamlining accessibility to aggregate data.
  • Transition existing reports from Excel to Power BI and prefer creating new reports in Power BI.
  • Document ETL processes, SQL queries, and metric calculations in Jupyter Notebooks, Data Catalogs, and/or Data Dictionaries.
  • Assemble customer, product, financial, transactional, and site browse data from multiple large-scale on-prem and cloud-based systems using SQL.

Qualifications

  • 4+ years of experience in a SQL/BI Engineer role, with at least two years in a business setting, preferably with a multi-channel contact center, or in a management/internal consulting role where analytics is a central area of focus.
  • Highly proficient in using SQL, Power BI, Power Query, and Excel for data analytics and reporting.
  • Adept at drawing insights from complex, large-scale data sets.
  • Experience creating documentation for data components such as Data Warehouse architecture diagrams, database entity diagrams, data flow diagrams, and SQL queries in Jupyter Notebooks.
  • Curious, life-long learner, self-motivated and able to work independently or as part of a team.
  • Bachelor's degree or equivalent job experience in Statistics, Economics, Analytics, Data Science, or other related field required.
  • Contact Center experience knowledge a plus.


Posted On: Tuesday, September 14, 2021



Apply to this job
or