Advanced Systems Design · 1 week ago
Data Warehouse Analyst, Advanced
Tallahassee, FL
Full-time
Onsite
Senior Level
7+ years expAdvanced Systems Design is seeking a Data Warehouse Analyst, Advanced for our client located in Tallahassee, FL. The role involves gathering business information needs, performing data analyses, and managing data in a Snowflake cloud environment while utilizing various data analysis tools.
Information TechnologyManagement ConsultingService Industry
Responsibilities
Responsible for gathering and assessing business information needs and preparing system requirements
Performs analyses, development, and evaluation of data mining in the Snowflake cloud data warehouse environment, which includes data design, database architecture, and data management utilizing Informatica PowerCenter, Intelligent Data Quality, and Enterprise Data Catalog
Uses data mining and data analysis tools, including Power BI and Tableau
Reviews and validates data loaded into the data warehouse for accuracy
Interacts with the user community to produce reporting requirements
Provides technical consulting to users of the various data stores and advises users on conflicts and inappropriate data usage
Responsible for prototyping solutions, building solutions, preparing test scripts, and conducting tests for Snowflake data population, including data replication, extraction, loading, cleansing, and transforming the data
Responsible for enterprise data modeling
Maintains knowledge of software tools, languages, scripts, and shells that effectively support the Snowflake cloud data warehouse environment
Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools
Strong Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks
Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development
Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics
Coaches and mentors’ peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse
Prototypes, builds, and tests Power BI and Tableau reports and dashboards
Assists with the development and maintenance of methods and practices documentation
Qualification
Required
At least 7 years of IT experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions
Experience designing data models for Business Intelligence tools like Power BI and Tableau
Experience with Informatica on-premises products like PowerCenter and Data Quality
Experience with ELT with Change Data Capture solutions like PowerExchange
Experience with IBM Mainframes, COBOL, JCL, and DB2 analysis
Experience with IICS Cloud Administration and Snowflake Data Cloud Administration
Ensures data warehouse metadata is collected and maintained
Experience with Informatica IICS Cloud Performance Tuning
Experience with Snowflake Data Cloud Performance Tuning
Experience with Data Governance products, like EDC, Axon, and CDGC
Bachelor's Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement
Preferred
Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake
Benefits
Comprehensive Health Insurance with PPO and HDHP/HSA options
Dental Insurance
Vision Insurance
Short/Long-Term Disability
Group Life Insurance - Company Paid
Voluntary Life Insurance
401(k) Plan with Employer Match
Paid Time Off (Vacation/Sick)
Holiday Pay - Company Paid Federal Holidays
Professional Certification Incentive Plan
Employee Referral Plan
Technology Exposure
Company
Advanced Systems Design
Over the years, ASD has grown into one of the Southeast's premier providers of web solution, application development, management consulting, IT consulting, networking/collaboration, and IT staffing services to the government sector.
51-200 employees
H1B Sponsorship
Advanced Systems Design has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
Funding
Current Stage
Growth StageTotal Funding
$1.32M2010-08-17Series Unknown· $0.55M
2009-06-09Series Unknown· $0.78M
Company data provided by crunchbase