Data Modeler II

Company: Peak Performers
Location: Austin
Posted on: February 20, 2021

Job Description:

Peak Performers is a nonprofit recruiting firm specializing in contract roles with state of Texas government agencies. We've partnered with the Employee Retirement System (ERS) to recruit for a Data Modeler II in Austin, TX. Your tasks

• Gather business requirements and translate these into data models for the data warehouse and for agency-wide analytics
• Conduct and lead discussions with business leads and SMEs to understand and document the scope and business requirements, and translate these into the technical design
• Interface with key stakeholders to define, analyze, and deliver requirements that reflect the needs of the business, and translate to detailed design specifications
• Lead in the creation, development, implementation, configuration, maintenance, and support of data models for data marts and data warehouse
• Collaborate on the definition, development, and maintenance of standards and processes
• Proactively investigate and troubleshoot technical challenges, and provide corrective action
• Identify potential design, process and/or system changes to optimize performance, and mitigate risks
• Research, troubleshoot, and resolve data issues impacting report and data deliveryYou have 7 years of experience in
  • Data analysis, business analysis, or data warehousing
  • Data modeling
  • T-SQL, SQL management studio
  • Creating technical documentation, including data dictionaries and data flow/transformation process and architecture to both business and technical audiences
  • Government, health/life insurance, finance or investmentsYou may also have
    • Advanced knowledge of applying data architecture patterns to EDW dimensional models based on business and technical requirements
    • Good communication and interpersonal skills for interacting and collaborating with developers, analysts, and business staff throughout the organization
    • Experience with ERP systems (i.e. PeopleSoft, JDE, Workday, etc)
    • Knowledge of star schema dimensional design principals
    • Knowledge of health care claims dataProject termCompensation: $60.00/ph (W2)Work Location: 200 E. 18 th Street, Austin. TX 78701Work Schedule: Monday through Friday, 8:00AM to 5:00PMAssignment Length: Starting Asap and continuing for 6 months (Remote while covid restrictions are in place) Our client Established in 1947, the Texas Employees Retirement System (ERS) works to enhance the lives of state employees, retirees, and their dependents through the agency's successful project planning, budget activities, and prioritization. Emphasizing teamwork and collaboration, ERS aims to: support their members' retirement income security, sustain competitive group benefits programs, engage stakeholders for informed decision making, and enhance agency performance and accountability. ERS' tasks are critical to supporting former public employees in retirement and beyond. What's it like to work for Peak Performers?
      • Qualified applicants with chronic medical conditions and/or disabilities receive job preference.
      • Our clients can hire you at any time - with no fee! We want you to get hired.
      • We pay weekly through direct deposit.
      • We offer ACA compliant health insurance after 60 days.
      • In business since 1994, our relationships span 25 years and thousands of job placements. All employment offers are contingent on the successful completion of a pre-employment criminal background check, in compliance with all applicable federal and state laws. Applicants for employment with Peak Performers must possess work authorization that does not require sponsorship for a visa now or in the future. Peak Performers is an equal opportunity employer and will consider all applicants without regard to race, marital status, sex, sexual orientation, gender identity, genetic information, family/parental status, age, color, religion, national origin, veteran status, disability or any other characteristic protected by law. Peak Performers does not accept unsolicited resumes from headhunters, recruitment agencies or fee-based recruitment services. #peakperformers - provided by Dice

Keywords: Peak Performers, Austin , Data Modeler II, Other , Austin, Texas