Job description
At Mercantile Bank, we are dedicated to our Customers, Employees and Communities. Our exceptional team members are committed to maintaining an environment of personal growth and development while providing professional and personalized service to customers and supporting our diverse communities.
Employees are our most valuable asset! If you have an interest in joining a team that operates with INTEGRITY and PURPOSE, consider Mercantile Bank as a potential employer.
SUMMARY
This is a great opportunity to be Mercantile's first Data Engineer! This newly created position will manage a variety of duties related to the onboarding, testing, management, maintenance and analysis of bank data. You will assist with managing the bank's data warehouse environment and software and related systems, processes, procedures and change controls as well as related technical and end-user training. Your self-motivated drive, emphasis on detailed planning and problem-solving skills will provide business value and measurable outcomes for the entire company.
You would be eligible for a full benefits package that includes medical, dental, vision, a flexible spending account (FSA), 4 weeks paid vacation, sick time, life insurance, a 401(k) with a match at 100% up to the first 5% of your contribution, discounted bank services, adoption assistance, exceptional training and development opportunities, and more!
JOB DUITIES
- Design, configure, develop, test, and deploy ETL processes and self-service reporting assets that provide solutions to end users.
- Research, adapt, and follow best practices for data warehouse management.
- Design, build and improve data models to support the bank's strategic goals.
- Manage existing data transformation processes using data extraction and transformation tools such as Monarch.
- Manage MoveIT Automation tasks for file movement that feed data warehouse processes.
- Participate in data cleansing and profiling efforts and trace data quality issues to their source.
- Contribute to Data Governance, system documentation and sharing of data asset knowledge.
- You will work closely with business units and their leaders to analyze and compile business requirements that support critical business processes.
- Your past experience using a variety of relational and dimensional data resources combined with your experience in software development toolkits and fluency in multiple programming languages will be intracule to the design, testing, root cause analysis and deployment of solutions for the business.
- Your forward-thinking abilities and your understanding of the current and future states will aide in the vision of the data management domain.
- You will articulate pros/cons and makes timely recommendations to leadership.
QUALIFICATIONS
- 5-8 years Job-related experience in the following areas is required for this position:
- The candidate must have 5+ years' experience in the following: a strong working knowledge of relational database management systems (Microsoft SQL Server).
- Data wrangling experience using a variety of tools and languages. Experience with SQL (data definition, stored procedures, scripts). Strong technical writing and presentation skills.
- Data visualization experience in common business intelligence tools (Tableau/Power BI).
- Capability to design and document conceptual, logical, and physical data models for relational and dimensionally modeled databases.
- Familiarity with various raw data source types and how to interpret them. (Unstructured -JSON, Flat files).
- Familiarity with scripting languages such as R and Python.
- Experience interacting with and extracting data from modern web APIs.
- Experience with cloud platforms such as AWS and Snowflake.
- A bachelor's degree, or achievement of formal certifications recognized in the industry as equivalent to a bachelor's degree (e.g. information technology certifications in lieu of a degree). Equivalent job-related education and/or experience will be considered if the necessary knowledge, skills and abilities to perform the functions of the job are proven.
- Banking experience preferred.
We believe embracing human diversity makes us a better bank. We know it makes us better people.
Employees with dissimilar backgrounds, perspectives, opinions and lifestyles help us understand the motivations and desires of our many different customers. Thus, we will strive to maintain a workforce that reflects the increasing diversity of the communities we serve by ensuring equal employment opportunity for all persons without discrimination on the basis of race, color, religion, sex/gender (including gender identity), national origin, age, height, weight, disability, medical condition, genetic information, sexual orientation, disabled or Vietnam era veteran, other forms of military status, marital status, or other protected characteristics.