1. Data Integration
-Using cloud technology, combine data from various sources, cloud and on-premises, based on requirements
-Perform data cleansing and standardization
-Load data into a cloud data warehouse as projects dictate
-Using the enterprise ETL tool, create modify, and improve integration pipelines
-Translate business requirements into data warehouse pipelines using ETL/ELT methodologies
-Extract and load many disparate systems into a centralized data warehouse
2. Business Intelligence & Data Analysis
-Assist with preparing and loading data for Analysis and BI reports and dashboards
-Identify opportunities for new data sources
-Collaborate with analysts to come up with creative solutions to data challenges
3. Ongoing Responsibilities
-Import and integrate new data sources based on business need
-Proactively identify potential data problems, but react as needed to unexpected issues
-Improve existing processes to streamline efforts
-Handle multiple projects and meet deadlines
-Monitor, schedule, and maintain existing integrations
4. Special projects and assignment as business dictates
5. Responsible for the maintenance, creation and control of all personally identifiable information or any other information protected by any Confidentiality or Privacy Standards or Company policies that you have access or knowledge of, including but not limited to any state or federal regulations including HIPAA
-Bachelor’s degree in information systems, Computer Science, or related field
-2-3 years of experience working with data using SQL or similar technology
-Very high attention to detail
-Familiarity with a data integration platform, such as Snaplogic, SSIS, or Informatica
-Familiarity with BI Visualization tools, such as Tableau
-Ability to work on multiple projects in a fast-paced environment
-Strong communication skills to all levels of technical expertise
-Must have attention to detail and focused concentration
-Must be able to learn new tasks and complete tasks independently
-Must be able to make timely decisions in the context of the workflow
-Must possess strong organizational skills, ability to multi-task and responsiveness
-Must be able to complete tasks that require a particular speed or productivity quota