Data Warehouse Analyst at Beacon Systems Inc BeaconGov
Tallahassee, FL 32301, USA -
Full Time


Start Date

Immediate

Expiry Date

14 Oct, 25

Salary

65.0

Posted On

16 Jul, 25

Experience

7 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Critical Thinking, Power Bi, Data Warehouse, Powercenter, Team Building, Communication Skills, Business Intelligence Tools, Analytical Skills, Leadership, Presentations, Documentation, Decision Making, Dashboards, Customer Service, Data Models, Snowflake

Industry

Information Technology/IT

Description

Beacon Systems, Inc, delivers Program Management, Science, Engineering, and Technology Solutions to Federal, Commercial State, and Local Agencies. We are a subsidiary of Radiant Digital Solutions. Our Technology support to many DoD Agencies, NASA, Voice of America, FDA, and State Agencies such as State of FL, RI, MS, ND, VA, and WV extends our delivery of solutions worldwide.
We are looking for a Data Warehouse Analyst - Tallahassee, FL.
If you are interested in applying for this requirement, please do respond with your updated resume.

EDUCATION

  • Bachelor’s degree in Computer Science, Information Systems, or related field
  • Or equivalent work experience

EXPERIENCE

  • Minimum 7 years of IT experience utilizing data management tools, business intelligence tools, and data warehousing
  • Extensive experience with Informatica PowerCenter and Snowflake preferred

JOB-SPECIFIC KNOWLEDGE, SKILLS, AND ABILITIES (KSAS)

  • Experience designing data models for BI tools like Power BI and Cognos
  • Strong development experience with Snowflake Data Cloud
  • Experience developing reports and dashboards in Power BI and Cognos
  • Proficiency with Informatica on-premises tools such as PowerCenter and Data Quality
  • Skilled in IDMC Cloud and Snowflake Data Cloud administration
  • Experience in performance tuning for Informatica IDMC Cloud and Snowflake Data Cloud
  • Ability to ensure data warehouse metadata is collected and maintained

GENERAL KNOWLEDGE, SKILLS, AND ABILITIES

  • Initiative: Ability to comprehend assignments, organize workload, and meet deadlines independently; proactive in analyzing situations and determining next steps
  • Communication: Clear verbal and written communication skills in various settings (meetings, presentations, documentation)
  • Customer Service: Skilled in assessing customer needs and resolving problems effectively
  • Decision Making: Capable of sound, objective decision-making based on analysis and critical thinking
  • Flexibility: Open to change, new processes, and constructive feedback; adaptable to shifting conditions and priorities
  • Interpersonal Skills: Courteous, polite, and cooperative with colleagues and stakeholders
  • Leadership: Ability to motivate, encourage, and guide others, adapting leadership style to different situations
  • Problem Solving: Strong analytical skills to identify issues, evaluate solutions, and recommend actions
  • Team Building: Promotes collaboration and shared goals as a contributing team member
  • Quality Assurance: Knowledgeable in quality assurance principles, techniques, and tools, and able to apply them in practice.
    Job Type: Contract
    Pay: $60.00 - $65.00 per hour

Experience:

  • Data warehouse: 7 years (Required)
  • Informatica: 7 years (Required)
  • IDMC: 7 years (Required)

Ability to Commute:

  • Tallahassee, FL 32301 (Required)

Work Location: In perso

Responsibilities
  • Perform strong data integration and data warehousing tasks using Informatica IDMC tools (e.g., IDMC CDI, MI, CAI)
  • Execute data integration processes including extraction, transformation, and load (ETL or ELT)
  • Administer IDMC platform, Secure Agent Infrastructure, and Snowflake Data Cloud platform for statewide adoption
  • Analyze transactional data stores and develop data warehouse models to optimize reporting and analytics
  • Work with relational databases such as DB2, SQL Server, Snowflake, and Oracle
  • Administer Red Hat Linux applications including security patching, filesystem management, wrapper and auto-startup scripts
  • Utilize IDMC Connectors for Change Data Capture solutions such as PowerExchange, as well as other connectors (e.g., relational, ServiceNow)
  • Assist with developing and maintaining methods and practices documentation
  • Analyze IBM Mainframe systems including COBOL, JCL, and DB2
Loading...