What are the responsibilities and job description for the Data Warehouse Specialist position at JPI?
JPI is seeking a self-starter to assist senior-level clients and leadership within a government client leading in the senior data warehousing environment. This role will work directly in a highly charged and fast-paced environment as a main point of contact. This position will be working in the highest technical level of all phases of the application programing.
At JPI, we strive to empower our people and excel for our clients. We hold ourselves to high standards and prioritize our values of being one team with unwavering integrity. We are motivated by our mission and driven to deliver solutions that exceed expectations. Will you join us?
This is a W2 or 1099 opportunity.
This role is contingent upon contract award.
Responsibilities Include:
- Demonstrate excellence in time management, including the ability to manage timelines, scope, and deliverables effectively. This includes working collaboratively and understanding project requirements to meet business objectives.
- Offer responsive support to address user queries and issues.
- Effective communication skills to collaborate with stakeholders, gather design and reporting requirements, and translate business needs into actionable and intuitive solutions.
- Strong interpersonal skills for leading and collaborating with cross-functional teams.
- Demonstrated experience in managing relationships with internal and external stakeholders.
- A commitment to staying updated on emerging trends, technologies, and best practices. The ability to adapt to evolving business and technological landscapes is crucial.
- Proven ability to analyze complex problems, make informed decisions, and drive solutions.
- Experience in implementing and enforcing data governance practices.
- Ability to effectively communicate complex technical concepts to non-technical stakeholders.
Requirements
- A preferred 8-10 years of hands-on experience in designing, implementing, and maintaining data warehousing solutions to also include data cube.
- Expertise in data modeling techniques and tools to design efficient and scalable data warehouse architectures.
- In-depth knowledge of batching and real-time ETL processes and tools for efficiently extracting, transforming, and loading data into the data warehouse, ensuring data integrity and optimal performance.
- In-depth knowledge of cube technologies such as OLAP (Online Analytical Processing) and familiarity with tools like Microsoft Analysis Services or similar platforms for multidimensional data modeling.
- Strong proficiency in database management systems, particularly those relevant to data warehousing, such as Oracle, SQL Server, SSIS, DEC-Azure, and Secure File Transfer Protocol (SFTP)
- Proven proficiency in data modeling techniques, with a focus on multidimensional modeling to support cube technologies and enable efficient data analysis.
- Familiarity with business intelligence tools such as Power BI, to enable effective data visualization and reporting on top of the data warehouse.
- Proficient in programming languages such as SQL, for data manipulation, transformation, and automation within the data warehousing environment.
- A bachelor’s degree in computer science, Information Technology, Data Science, or a related field is required. A master's degree can be advantageous.
- Federal government experience and active clearance and/or EOD preferred
JPI is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
