Data Engineer

at  Golden State Foods

EDUCATION/CERTIFICATION

• Four year college or commensurate work experience. 5+ years - Knowledge of AWS Infrastructure including S3, Redshift and RDS. Must have hands on client experience.
• Expertise in MS Excel.
• Expertise in SQL and relational databases
• Strong communication (verbal and written) and interpersonal skills to translate key insights from complex analyses into actionable business insights- Proven ability of looking at solutions in unconventional ways- seeing opportunities to innovate and leading the way- Strong proficiency in SQL- Creative in finding new solutions and designing innovative methods, systems and processes - Advanced degree in Science and Technology related field
• Experience with building multi-dimensional data models to serve as a foundation for future analyses- Experience with predictive modeling - Experience with IoT, Machine Learning, and AI- Strong analytic skills for working with unstructured datasets - Experience with connecting data sets to data visualization tools and creating reports using Tableau and Power BI
• Strong project management and organizational skills, experience working on complex initiatives with cross-functional teams in a dynamic environment
• Experience with Dell Boomi
• Experience with data visualization tools like Tableau and Microsoft Power BI

PREFERRED QUALIFICATIONS

• Expert in ETL and/or other data manipulation languages such as Python, SAS and R
• Experienced knowledge of AWS Infrastructure including S3, Redshift and RDS
• Industry experience as a Data Engineer or related specialty (e.g. Software Engineer, Business Intelligence Engineer, and Data Scientist) with extensive professional experience and a proven track record in a role focused on understanding, manipulating, processing and extracting value from large disconnected datasets.
• 3+ years of analysis experience
• Desire to create and build new predictive/optimization tools for structuring datasets

BUSINESS INTELLIGENCE DATA ENGINEER ANALYST TASKS

• Provide application analysis and data modeling design to collect data for centralized data warehouse.
• Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
• Proficient in the use of query and reporting analysis tools.
• Standardize data collection by developing methods for database design and validation reports.
• Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
• Map source system data to data warehouse tables
• Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
• Define and capture metadata and rules associated with ETL processes
• Adapt ETL processes to accommodate changes in source systems and new business user requirements
• Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
• Provide support and maintenance on ETL processes and documentation
• Build partnerships across the application, business, and infrastructure teams
• Strive to continuously improve the software delivery processes and practices
• Champion company standards and best practices
  75%

1. Additional Responsibilities

• Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA),
• Other responsibilities and accountabilities may be assigned based on business and organization needs.
• Sets priorities for other team members on a particular initiative or project.
• Manages user expectations regarding appropriate milestones and deadlines.
• Will assist in orientation, training, work assignment and checking of less experienced developers and analysts.
• Serves as technical consultation to leaders in the IT organization and functional user groups.
• Provides documentation and status updates on behalf of a larger IT group or work stream.
• Collaborates with customers and stakeholders as well as other members of IT.
• Provide continuous improvement and implementation of ideas
• Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA),
• Other responsibilities and accountabilities may be assigned based on business and organization needs.

25%
Qualifications: