Job Description
Data Modeler
Sterling Heights, MI
Contract - 1st Shift, 9/80
Pay Rate: $61.22/Hr
Benefits: overtime, medical, dental, vision, 401k
Travel: 10%
*Hybrid: 3 days in office, 2 remote
REQUIREMENTS: Data Modeler
Key Responsibilities: Data Modeler
Sterling Heights, MI
Contract - 1st Shift, 9/80
Pay Rate: $61.22/Hr
Benefits: overtime, medical, dental, vision, 401k
Travel: 10%
*Hybrid: 3 days in office, 2 remote
REQUIREMENTS: Data Modeler
- Bachelor's degree in data management, Data Science, Math, Statistics or equivalent
- Minimum 6 years of relevant experience
- Excellent oral and written communications.
- Be directly involved in developing data models and process flows as well as liaising with multiple stakeholders - mainly engineering, to document and/or validate the current state or As-Is business process.
- Proven ability to work within teams in which your contributions are critical to success.
- Proficiency with tools such as Power BI, Visual Basic, MS Excel, MATLAB/Simulink, Mathcad, MagicDraw, Midas, AWS/AWS Redshift, SSAS, Alation, Dataiku, Oracle, SQL.
- Experience using entity-relationship diagrams (ERDs), dimensional modeling, normalization techniques, and metadata repositories to design and document data structures.
- Understanding of data warehousing concepts.
- Experience with big data technologies like Hadoop or Spark.
- Familiarity with cloud-based data services such as AWS or Azure.
- Background in data governance and data quality concepts.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills with both technical and non-technical stakeholders.
- Experience in Agile or Scrum environments.
Key Responsibilities: Data Modeler
- Design and implement conceptual, logical, and physical data models to represent organizational data accurately.
- Collaborate with business analysts, data architects, developers, and other stakeholders to gather requirements and ensure models meet business and technical needs.
- Maintain a central data dictionary, enforce data standards, and ensure compliance with data governance policies.
- Optimize performance of data infrastructure by tuning data models for efficiency, reduce redundancy, optimize reusability at the right levels and improve database performance.
- Design solutions for integrating data across systems and perform reverse engineering of existing databases when necessary.
- Develop and maintain documentation, naming conventions, and coding standards to ensure consistency across data systems helping the business to define what does good look like?
- Ensure that data is stored securely, efficiently, and in a manner that is accessible for analysis and reporting.
- Ensuring the accuracy, consistency, and reliability of data, implementing data validation and quality control processes.
- Optimize data pipelines for speed, scalability, and performance, ensuring that data is available when and where it's needed.
- Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and ensure that data infrastructure meets their needs.
- Troubleshoot issues with data infrastructure, monitor system performance, and perform regular maintenance to ensure smooth operation.
- Support configuration control, documentation and change impact analysis on the businesses data architecture model including identification of Authoritative Source Of Truth (ASOT) databases, connectors to replicate data from ASOTS to Midas and/or AWS Cloud Environments through data transformation within Power BI.
- Experience with structured problem-solving techniques
- Knowledge of technical requirements and systems relevant to Combat Vehicles
- Experience working with development teams
- Knowledge of metrics related to Agile and use of them to report back to team members at all levels
- 1+ years of Scrum/Agile management
- In-depth knowledge of Engineering and/or manufacturing environments
- 10 or more years of relevant work experience
- Masters degree in mathematics, statistics, business, engineering, physical/applied sciences, or management discipline (business administration, accounting, finance, economics or management information technology)
Numbers & Facts
| Location | Sterling Heights, MI |
| Industry | Other/Not Classified |
| Company Size | 100 to 499 employees |
| Year Founded | 1983 |
| Website | http://apollopros.com/ |
About Company
Apollo Professional Solutions was founded by Gayle A. Williams in 1983 as a technical staffing firm supporting New England aerospace companies. Today, Apollo has grown into a $40 million year company, with 5 regional offices nationwide that offers diversified support to industries that include: defense, military, aeronautical, civil, food & beverage, healthcare, marine, pharmaceutical and scientific industries, as well as local government. We are an equal opportunity employers, that is also certified as a Women’s Business Enterprise by WBENC as well as the State of Massachusetts (SOWMBA Office.)
Skills
- Accountingunmatched
- Agile Programming Methodologiesunmatched
- Amazon Web Services (AWS)unmatched
- Analysis Skillsunmatched
- Apache Hadoopunmatched
- Apache Sparkunmatched
- Big Dataunmatched
- Blueprintsunmatched
- Business Administrationunmatched
- Business Analysisunmatched
- Business Architectureunmatched
- Business Modelunmatched
- Business Processesunmatched
- Business impact analysis (BIA)unmatched
- Change Controlunmatched
- Cloud Computingunmatched
- Coding Standardsunmatched
- Communication Skillsunmatched
- Data Analysisunmatched
- Data Managementunmatched
- Data Modelingunmatched
- Data Qualityunmatched
- Data Scienceunmatched
- Data Setsunmatched
- Data Structuresunmatched
- Data Warehousingunmatched
- Database Replicationunmatched
- Design Documentunmatched
- Dimensional Modelingunmatched
- Document Managementunmatched
- Documentationunmatched
- Economicsunmatched
- Entity Relationship Diagram (ERD)unmatched
- Financeunmatched
- Identify Issuesunmatched
- Information Technology & Information Systemsunmatched
- Maintain Complianceunmatched
- Management Strategyunmatched
- Manufacturingunmatched
- Mathematicsunmatched
- Metadataunmatched
- Metricsunmatched
- Microsoft Windows Azureunmatched
- Performance Analysisunmatched
- Performance Managementunmatched
- Performance Tuning/Optimizationunmatched
- Physical Scienceunmatched
- Power BIunmatched
- Presentation/Verbal Skillsunmatched
- Problem Solving Skillsunmatched
- Process Flowunmatched
- Quality Controlunmatched
- Regulatory Complianceunmatched
- Requirements Managementunmatched
- Reverse Engineeringunmatched
- Scrum Project Management and Software Developmentunmatched
- Statisticsunmatched
- Structured Dataunmatched
- System Integration (SI)unmatched
- Systems Analysisunmatched
- Team Playerunmatched
- Time Managementunmatched
- Willing to Travelunmatched
- Writing Skillsunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder