Data Modeler
Start a Rewarding Career with Alliant
What will your day look like?
You will be responsible for setting the strategy for the translating business requirements into the Data Warehouse data model for use in the Business Intelligence platform, to oversee the development of data extraction and integration routines and to incorporate data quality and validation routines. This position will also create/maintain the logical and physical data models, lead the effort for a Business Glossary to empower Self-Service Analytics, and for conversion of business requirements into detailed technical designs. You must understand the dimensional/relational modeling techniques and bridge the gap between the OLTP developers, data warehouse developers, and DBA teams.
A key responsibility is to work with business stakeholders and peers (such as Business Analysts, Data Integration and Business Intelligence Engineers, DBAs, and business owners) to enhance the organization’s enterprise data warehouse.
The Data Modeler will be expected to leverage their deep technical knowledge of data modeling and data integration best practices along with cross industry data expertise to empower the business to make data-driven decisions.
Responsibilities
Do you see yourself doing this?
- Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
- Expert knowledge in dimensional data modeling, ETL processes, data integration applications and business intelligence tools. SAP Business Objects and Tableau a plus.
- Interacts with OLTP systems and translated relational models into dimensional models.
- Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance
- Participates in collaborations to transform business requirements into ETL and data validation designs. This includes knowledge sharing and mentoring fellow team members.
- Evaluates source system data and data models
- Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
- Address data related problems in regards to systems architecture, integration, compatibility, and multiple-platform integration
Qualifications
What makes you a great fit?
You’ll be a great fit if in addition to the Completion of a Bachelor’s degree in Computer Science or a related field, 3+ years of experience writing and tuning complex SQL (T-SQL in SQL Server), and you have:
- Experience with software quality assurance testing, release procedures, coding design and documentation protocol.
- Solid experience using Informatica PowerCenter in a Data Warehouse environment. Experience in Informatica Data Transformation and Metadata Manager a plus.
- Proven success working in a collaborative and Agile environment (Scrum methodology a plus).
- Demonstrates analytical thinking and strong problem solving skills
- Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design
- Experience or exposure to SAP Business Objects & Crystal, Tableau, Hadoop, and CA ErWin
- Proven background designing and architecting ETL solutions as part of a cross-functional team
- Experience in making hardware recommendations, sizing, and configuration for development systems
- Experience in Hybrid Cloud based implementations and architecture preferred. Azure experience a plus.
When you’re happy, we’re happy!
As a thank you for joining our team, you’ll benefit from:
- Competitive medical, dental, and free vision benefits
- Competitive compensation plan
- Contributions towards gym memberships
- Generous PTO and banking holidays off