The company is looking to solve the problem of driving data-informed decision-making across the organization through the design, development, and optimization of enterprise business intelligence solutions.
Requirements
- Proven expertise in delivering enterprise-grade BI solutions using the full Microsoft BI stack, including advanced development in SSIS, SSRS, and SSAS.
- Advanced SQL proficiency, including the ability to design and optimize complex queries, stored procedures, and performance-tuned database operations.
- Deep knowledge of database engineering and data architecture, with strong command of STAR and Snowflake schema design and extensive hands-on experience loading and maintaining large-scale data warehouses.
- Expert-level proficiency with self-service BI tools such as Power BI, Tableau, Sisense, or Qlik, including modeling, DAX/MDX, visualization design, and governance best practices.
- Strong working knowledge of Microsoft Dynamics GP and its data structures, with the ability to translate ERP data into actionable BI solutions.
- A minimum of 5-7 years’ experience with relational database and data warehouse concepts.
- Bachelor’s degree in computer science, information systems, data science, information technology or a related field.
Responsibilities
- Lead integration initiatives to merge, modernize, and optimize BI platforms with enterprise systems and critical business applications.
- Architect and oversee the design of enterprise databases, data warehouses, data marts, and data models to ensure scalability, interoperability, and long-term performance.
- Drive the end-to-end development of advanced BI solutions, including data warehouses, data marts, analytical datasets, reports, and executive dashboards.
- Design, optimize, and govern complex ETL/ELT workflows, ensuring efficient, accurate, and reliable data movement while translating high-level business needs into robust technical specifications.
- Develop, enhance, and deploy interactive analytic dashboards and reporting solutions that deliver high-impact insights for leaders and stakeholders across the organization.
- Lead the design, development, and optimization of SSAS cubes to enable multidimensional analytics and scalable business intelligence capabilities.
- Transform complex data into strategic insights, delivering actionable recommendations that drive data-informed decision-making at all levels of the organization.
Other
- Bachelor’s degree in computer science, information systems, data science, information technology or a related field.
- A minimum of 5-7 years’ experience with relational database and data warehouse concepts.
- Exceptional collaboration and interpersonal skills, with a proven ability to work cross-functionally and mentor junior team members within BI and technical teams.
- Preference for Central or Eastern time zone working hours.
- Work is performed in a remote environment with extensive computer and screen time.
