Note: The job is a remote job and is open to candidates in USA. HOLT Group is a renowned, family-owned company with a legacy spanning nearly a century. They are seeking a Software Engineer 2 responsible for modeling and documenting data assets, implementing reporting and analytics, and managing critical data structures.
Responsibilities
- Responsible for modeling and documenting data assets, and implementing reporting and analytics
- Responsible for defining and managing critical data structures for current and future needs
- Gather business requirements and translate those requirements into logical data models
- Create technical design specifications including data classifications
- Source target mapping documentation for data integration and warehousing engineers
- Lead data discovery discussions with stakeholders in JAD sessions and map the business requirements to logical and physical data modeling solutions
- Create entity level data models from a business perspective for a particular scope
- Provide logical data models for particular scopes using a business perspective
- Translate logical data models for implementation in specific data base technologies
- Provide technical expertise in support of detailed database designs and design documentation production, including data models and data flow diagrams
- Plan and coordinate conversion and migration of existing or legacy databases to support the availability, usability, integrity, and security of data
- Perform technical evaluation of existing models for legacy applications and create new models in support of reusable and composable integration architecture
- Perform data analysis and data modeling for operational and analytical needs
- Develop entity relationships (ER models) for normalized and dimensional models
- Capture technical metadata through data modeling tools
- Provide technical consulting for application teams for data naming, classification, design, and handling as a part of the first line of defense for data controls in designing systems
- Collaborate with Data Architects for data model management, documentation, and version control
- Conduct data model reviews with other project team members such as Solution Architects, Data Architects, and Integration Engineers
- Develop data catalog capabilities and facilitates data stewardship and data management best practices
- Work closely with the data integration, warehousing, BI and other teams to develop appropriate data models
- Determine security procedures for system databases and central data stores to maintain the viability of and access to data based on organizational needs
- Utilize Tableau or other data visualization tools in addition to BI tools such as Power BI
Skills
- Bachelor's degree in Information Technology or related field plus 4 years of experience in data modeling supporting data solutions, integrations and design documentation production
- Data modeling experience in finance, commercial supply chains, sales and customer analytics
- Data transformation using ETL tools and technologies, and related concepts such as data catalog
- Translating and mapping relational data models into Data Base Schemas
- Capturing technical metadata through data modeling tools
- Residency in the state of Texas required
- 20% Domestic travel required
Company Overview