ETL Developer will be responsible for designing/implementing/managing ETL processes for ParkMobile data and reporting group.
Write, implement, and maintain appropriate ETL processes.
Schedule ETL jobs
Proactively recommend solutions that will best benefit the ParkMobile business.
Work closely with DBAs, Architects, Data Modelers, Business Analysts, and Product Managers at delivering high quality, reliable solutions.
Maintain data dictionaries.
Assist in writing and scheduling reports for various ParkMobile groups.
Design new and modify existing table structures, stored procedures, events, and external programs.
Provide appropriate data solutions for different types of applications: OLTP, OLAP, large data sets, etc.
Key Result Areas:
In the first 90-120 days, the ETL/Database Developer will need to become very familiar with the existing ETL processes and MySQL/MSSQL schemas used by ParkMobile. The person will need to understand the existing system setup and will need to take over the day-to-day maintenance of the existing ETL processes.
The ETL/Database Developer is accountable for:
Quickly documenting and soliciting information on database ETL processes (existing or new)
Ensuring that all processes are behaving as expected, that any potential issues (such as program errors, database issues, query executions) are addressed in a timely manner
Assisting in timely completion of ETL related tasks of projects
Keeping stakeholders and team members up to date on database project statuses, issues, and dependencies through effective communication methods.
Who You Are:
Four+ years of experience as ETL/Database Developer in both OLTP and OLAP environments.
Knowledge of multiple database platforms, such as MySQL, MSSQL.
Knowledge of non-relational data storages (Cassandra, MongoDB)
Knowledge of cloud-based data warehouse platforms (Redshift, Snowflake, etc.)
Excellent proficiency in SQL, T-SQL
Excellent proficiency in at least one reporting tool (Looker, Pentaho, Business Objects)
Experience with cloud platforms: AWS, S3, data lakes
Knowledge of scripting languages (such as Unix shell, Python, Go)
Demonstrated background in successfully delivering large technology projects
Ability to effectively communicate with teams in multiple locations.
Strong analytical and problem-solving skills.
A flexible attitude that enables the individual to deal comfortably with changing priorities.
Demonstrated knowledge and experience in project management processes and related methodologies
Demonstrated knowledge and experience in software development and IT infrastructure project lifecycles (e.g., waterfall, RUP, Agile, etc.)
Proficient with Microsoft Office applications (Word, Excel, PowerPoint, Visio, Project, SharePoint)
Required skills: MySQL 5.*, OLTP/DW, report writing, query tuning, troubleshooting, SQL, at least 2 of the scripting languages (Shell, Python, GO, groovy), ETL tools, cloud platforms