Roles and Responsibilities
- Responsible for managing and optimizing the customer s Data Lake/Warehouse, Business Intelligence, reports, and data analytics systems.
- Work and collaborate with senior client staff and staff throughout the Organization, create and maintain documentation related to enhancements, scripts, configurations, reports, and other changes to the systems.
- Design, develop, and maintain the Data Lake/Warehouse infrastructure, ensuring data integrity and performance optimization.
- Data modelling, data integration and ETL implementation
- Collaborate with stakeholders to define data requirements and ensure data quality and consistency.
- Monitor and troubleshoot Data Lake/Warehouse performance issues, implementing necessary optimizations.
- Develop and maintain interactive reports, dashboards, and data visualizations using Microsoft Power BI, Infor Birst or other BI tools.
- Implement data cubes, data mining, and advanced analytics techniques to support decision-making processes.
- Collaborate with business users to understand their analytical needs and provide training and support on BI tools.
- Perform data analysis, data mining, and statistical modelling to identify trends, patterns, and correlations.
- Utilize data visualization techniques to communicate analytical findings and insights effectively.
- Identify opportunities for process improvements and data-driven decision-making.
- Develop predictive models and implement machine learning algorithms to support forecasting and predictive analytics.
- Design and generate reports based on business requirements using various reporting tools.
- Perform data analysis on reports to identify trends, patterns, and opportunities for improvement.
Required Skills:
- Strong background in Data Lake/Warehousing technologies, Business Intelligence tools, and data analytics, with expertise in Amazon Data Lake, Infor Birst, Microsoft Power BI, Microsoft SQL and Oracle Database
- Knowledge of building data orchestration and pipelines.
- Understanding of metadata management, data modelling & design, data integration, data lineage, data catalog and related tools.
- Ability to understand the data needs of data users and quickly translate complex technical concepts into simplified business terms.
- Ability to transform complex data into easy-to-understand visual insights that are aligned to business objectives.
- Proficiency in SQL query language and able to use many query tools
- Stay up to date with the latest trends and advancements in Data Lake/Warehouse, Business Intelligence, and data analytics fields.
- Provide technical guidance and expertise to the team and other stakeholders.
- 4+ years of relevant experience
- Detail oriented
- Excellent communication skills
- Ability to manage one s time efficiently
- Ability to work independently and with a team
Amick Brown is an Information Technology consulting company specializing in ERP, Data Analytics, Information Security, Application Development, Networking, and Cloud Computing. The company was founded in 2010 and is headquartered in San Ramon, California.
Regular full-time employees are eligible for the following Amick Brown provided benefits:
- Health
- Vision
- Dental
- 401k with company match
- Paid time off
- Sick Leave
- Short-Term Disability
- Life Insurance
- Wellness & Discount Programs