Job Location: Detroit, MI
BCBSM is seeking a systems analyst II with a focus on data modeling to join our IT organization. To ensure success as a data modeler, you should have in-depth knowledge of data warehousing, as well as expert communication skills. Ultimately, a data modeler should be able to design models that reduce data redundancy, streamline data movements, and improve enterprise information management.
Data Modeler Responsibilities:
- Analyzing and translating business needs into long-term solution data models.
- Implementing data strategies and developing physical data models.
- Updating and optimizing local and metadata models.
- Evaluating implemented data systems for variances, discrepancies, and efficiency.
- Proficient in industry standard techniques for data modeling. The Data Modeler must be proficient in 3rd normal form relational modeling. Dimensional modeling experience would be a strong added value for online analytical processing.
- Experience in ERWIN tool
- Proven experience in an enterprise environment developing relational databases
- Proven experience developing models for Business Intelligence solutions Strong analytical, data profiling and problem-solving skills
- In depth knowledge of modeling methodologies and techniques.
Plan, develop, test and implement IT system solutions that improve business efficiency and productivity as well as support business strategies and goals. Identify and communicate business needs and translate business requirements into technical system and functional specifications. Support one or more moderately to highly complex business processes/systems for multiple business units. Project team member for projects medium to large in scope and high complexity.
-
Participate in business short-term planning sessions to ensure understanding of business goals, direction and business requirements; provide input from an IT systems perspective. Participate in the estimation of costs for the planning of new systems/enhancements for assigned systems. Serve as a liaison between business area and the IT organization and vendors in coordination with project managers to provide technical solutions that address user needs.
-
Translate business requirements into technical requirements. Formulate and define system scope and objective based on user needs and understanding of business processes. Develop, write, and communicate systems design, functional system specifications and functional architecture analysis. Identify gaps or issues.
-
Analyze customer’s systems and capabilities to understand strengths and weaknesses for the identification of opportunities for system improvement.
-
Develop user and/or system test cases and validate test results during testing, as needed. Document system modifications. Develop system manuals, system training materials and system enhancement communication.
-
Identify, investigate, resolve and escalate problems, as needed. Gather data to support recommendations to address problems. Procure technical assistance to help in problem resolution.
-
Work closely with developers and end users to ensure technical compatibility and user satisfaction.
-
Provide factual content to feasibility study for standard development projects and enhancements. Stay abreast of new and emerging technologies. Analyze technology trends to determine impact to the achievement of business goals. Identify issues based on impact of new/emerging technology or modifications to existing systems.
-
Provide input for the development of Service Level Agreements (SLAs) and/or forecasting activities as needed. Review performance against SLAs. Identify areas for improvement. Support achievement of SLAs.
-
Coach and mentor less experienced team members.
-
Other duties as assigned.
Qualifications
EDUCATION AND/OR EXPERIENCE
- Bachelor’s degree in related field preferred.
- Three (3) years of relevant system solution development, testing and implementation work experience required.
OTHER SKILLS AND ABILITIES
- Strong analytical, technical, interpersonal and communication skills.
- Knowledge of business operations, systems requirements and IT processes.
- Ability to work independently, or within a team environment.
- Other related skills and/or abilities may be required to perform this job.
Submit CV To All Data Science Job Consultants Across United States For Free