Under minimal supervision, conducts data modeling, data management and data transformation activities in support of the Logix Data & Analytics roadmap. Central to the success of the data maturity at Logix, this key contributor provides hands-on design and development expertise in the creation, deployment and management of data movement and transformation efforts that populate the Logix Data Lake and Central Data Repository.
* Creates complex SQL queries, develops APIs for data capture, transforms/translates JSON and XML into data tables and understands and can self-direct with regard to learning new methods of capturing and manipulating data. * Performs analysis, design, modeling and development of a fully integrated and related data environment within the Logix Data & Analytics organization. * Supports vendor efforts to create a central data repository using Microsoft SQL, AWS, Tableau and other related tools. * Develops end-to-end data lifecycle solutions that take data from source systems through the data lake and into the central repository and data warehouse environments. * Implements change control processes and designs a data lineage map in order to comply with data regulations both existing and proposed. * Manages and maintains access to Data Lake and Central Data Repository SQL databases and tables by Data & Analytics personnel such as Dashboard developers and Advanced Analytics team members. * Maintains both the Data Lake and central data repository for any changes, updates or additions of data processes to these environments. * Document processes, develops data warehouse and database objects, schedules and runs ETL jobs; develops and provides reporting on usage and growth of data objects and is the SME for both environments. * Partners with Data Management team as well as quality team to determine rules used in development of processes that ingest, move, clean and store data.
Education and/or Experience
* Bachelor's degree or equivalent work experience in statistics, data analysis, data development, database administration or information management. * Five to seven years of experience in ETL solutions such as Informatica and SSIS. * Expert in Advanced SQL and/or similar database languages such as PL/SQL. * Five to seven years of experience in database administration, job scheduling and/or data integration projects. * Knowledge of data warehouses, OLAP cubes, SQL Server Integration and Reporting services as well as a firm grasp of Business Intelligence concepts and tools. * Expertise in one or more programming languages (Java, Python) * Experience with complex data types such as JSON or XML. * Understands the Software Development Lifecycle. * Experience creating data maps (source to target mapping). * Understanding of concepts such as MDM, Metadata Management, Data Quality and Profiling. * Proven ability to translate business requirements into SQL code, SSIS packages or other technical artifacts. * Preferred experience with and understands "Big Data" and "Unstructured Data" concepts and technologies such as Hadoop * Preferred experience with cloud technologies such as AWS and Azure. * Experience with creating data flow diagrams and data models.
Must also demonstrate conduct consistent with our Corporate Values:
* Practice open Communication with all levels; * Be Accountable by taking ownership of customer issues and responsibility for one's actions; * Foster Teamwork by cooperating and collaborating with other employees; * Seek ways to make the workplace Fun for oneself & others; * Conduct oneself with Integrity by being honest, trustworthy and ethical in all work activities and interactions; * Work with a Service Orientation by having a genuine concern for the needs of one's customers and by being friendly, professional and following through on commitments; and * Demonstrate Humility in all interactions and remember to leave one's ego at the door when one arrives to work.
Logix Federal Credit Union is an equal opportunity employer that does not discriminate in employment opportunities or practices on the basis of race, religion, color, sex, sexual orientation, gender identity, national origin, protected veteran or disability status, or any other status protected by law.
Let your dream job find you.
Sign up to start matching with top companies. It’s fast and free.