Data Warehouse Specialist

The Role

We are looking for an experienced and energetic leader to join the team as a Data Warehouse Specialist. As a Data Warehouse Specialist, you will play a critical role in developing data warehouse solutions for our clients. You will be responsible for conducting assessments, developing strategies, and providing expert guidance to enhance their data governance.

Modali believes in giving each person a chance to succeed: you will be afforded the opportunities, resources, and autonomy to deliver quality, timely projects to our diverse client base.

TO APPLY: Please submit an application using the link on our website, modaliconsulting.com. 

Responsibilities

• Collaborate with clients to understand their business requirements and design effective data warehouse solutions.
• Develop and implement data warehouse architecture, data models, schemas, and structures.
• Demonstrate deep expertise in MDX query development, including complex multidimensional expressions and data manipulation.
• Proficiently use SQL, ETL tools, and programming languages to extract, transform, and load data, with a strong focus on MDX and BI query development.
• Design and implement efficient Extract, Transform, and Load (ETL) processes to populate and update data warehouses.
• Ensure data quality and integrity by establishing appropriate data validation and cleansing procedures.
• Optimize data warehouse performance through indexing, partitioning, and other performance tuning techniques.
• Implement effective backup, recovery, and security measures for data warehouses.
• Evaluate existing data frameworks and identify opportunities for improvement.
• Conduct in-depth data analysis to identify data quality issues, inconsistencies, and gaps.
• Recommend and implement enhancements to data frameworks to meet client requirements.
• Collaborate with cross-functional teams to define data governance policies, standards, and best practices.
• Conduct regular audits to ensure compliance with data governance guidelines.
• Participate in project planning and scoping activities, providing technical expertise on data warehouse solutions.
• Utilize data visualization tools to create meaningful reports and dashboards for clients.
• Stay up to date with the latest trends, tools, and technologies in data warehousing and business intelligence.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field. Relevant certifications (e.g., AWS) are highly desirable.
• Proven expertise in MDX query development and BI query development.
• Advanced proficiency in SQL, ETL tools, and relevant programming languages.
• Deep understanding of data modeling, dimensional modeling, and data warehouse design principles.
• Experience with data warehousing tools and technologies (e.g., Snowflake, Amazon Redshift, Microsoft Azure SQL Data Warehouse)
• Proficiency in at least one ETL tool (e.g., Informatica, Talend, SSIS).
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills to effectively collaborate with clients and team members.
• Ability to manage multiple projects and prioritize tasks effectively.
• Professionalism and client-oriented mindset, with the ability to establish trust and maintain confidentiality.

About

Who we are. Modali Consulting is a technology strategy and consulting firm, supporting private and public sector clients across a range of industries. Its primary capabilities are in data engineering, data science, project management, software development and design, analytics strategy, and solutions. Clients range from state and local governments, to Big 4 consulting firms, to product companies.

Modali Consulting prides itself on its staff and culture above all else because we are convinced that investing in people yields the best results. Its core principles are: (1) transparency and intellectual humility; (2) responsibility to each other; (3) commitment to challenging conventions; (4) failing forward and repeating success; and (5) fostering a cohesive and collaborative work environment for clients and employees alike. To learn more, go to www.modaliconsulting.com.

Diversity, Equity, and Inclusion. Modali Consulting is an inclusive equal opportunity employers committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, or gender identity.