Tallahassee, FL
Work authorization: any (candidate must be authorized to work in US)
Must-have skills: Data Warehousing Technologies: Snowflake, Informatica PowerCenter, Informatica Intelligent Data Quality, Informatica Enterprise Data Catalog; Relational database platforms (DB2, SQL Server, Oracle); Business Intelligence and Reporting Tools: Power BI, Tableau, Data Management and ETL: ETL (Extract, Transform, Load) processes, Data Modeling and Optimization: Data warehouse models, Data mart concept.
Requirements:
- Availability to work 3 days per week at the Client’s site in Tallahassee, FL (required);
- IT work experience utilizing data management tools, business intelligence tools, and data warehousing (7+ years);
- Experience in data warehouse and data mart concepts;
- Experience modeling transactional data for data warehousing usage;
- Experience in Snowflake cloud data warehouse functionality;
- Experience in Informatica PowerCenter functionality;
- Experience in Informatica Intelligent Data Quality functionality;
- Experience in Informatica Enterprise Data Catalog functionality;
- Experience in Power BI functionality;
- Experience in Tableau functionality;
- Experience in relational database platforms including DB2, SQL Server, and Oracle;
- Bachelor’s Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement.
Responsibilities:
- Responsible for gathering and assessing business information needs and preparing system requirements;
- Use data mining and data analysis tools including Power BI and Tableau;
- Provide technical consulting to users of the various data stores and advises users on conflicts and inappropriate data usage;
- Participate in strategic planning for the Snowflake enterprise data warehouse;
- Prototype, build, and test extraction, transformation, and load (ETL or ELT) jobs, data quality processes and related jobs, Power BI reports and dashboards, Tableau reports and dashboards;
- Coach and mentor peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse
- Assist with the development and maintenance of methods and practices documentation