Overview
On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)
Skills
Adaptability
Analytical Skill
Budget
Business Intelligence
COBOL
Change Data Capture
Cloud Computing
Collaboration
Communication
Computer Science
Customer Service
Dashboard
Data Integration
Data Management
Data Warehouse
Decision-making
Documentation
ELT
Extract
Transform
Load
Extraction
File Systems
IBM DB2
IBM Mainframe
Informatica
Informatica PowerCenter
Informatica PowerExchange
Information Systems
JCL
Leadership
MI
Management
Marketing Intelligence
Meta-data Management
Microsoft Power BI
Microsoft SQL Server
Performance Tuning
Presentations
Problem Solving
Quality Assurance
Red Hat Linux
Relational Databases
Reporting
ServiceNow
Snow Flake Schema
Startups
Job Details
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.
Position Title: Data Warehouse Analyst, C. Advanced
Location: Tallahassee, FL 32301
Contract Term: ASAP through 06/30/2026, with possible renewal based on performance, need, and budget.
Location: Tallahassee, FL 32301
Contract Term: ASAP through 06/30/2026, with possible renewal based on performance, need, and budget.
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
Primary Duties and 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
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.