Full Job Description
We9re looking for a talented and experienced data engineer to join our team in Atlanta, Georgia. A Data Engineer at TVS plays an important role in TVS9s success. Individuals in this role are expected and trusted to be responsible for supporting the firm9s financial and business data process and reporting systems in alignment with the firm9s mission, business strategy, and resources. This position places a priority on learning and growing into additional expertise and responsibility.
RESPONSIBILITIES:
- Support the responsibilities of the Senior Director of Data Analytics. Be mentored by and learn from the Senior Director of Analytics. Grow into expertise and further responsibilities.
- Support the firm9s financial and AEC project management data within the current data operating systems
- Assist in setup, configuration, security administration, changing and supporting our financial systems
- Assist in building custom reports in and integrations for those financial and management systems
- Assist building and supporting processes to pull data from the financial and management systems into a Microsoft SQL Server Database system to retain control, archive, and support reporting, data integration, and analytics
- Assist in managing our Microsoft SQL Server Databases and building database objects and SQL code such as security, schemas, tables, keys and indexes views, functions, stored procedures, and scheduled jobs. Assist with SQL Server Database backup and recovery processes.
- Assist in building database integration between financial systems using Microsoft SSIS (SQL Server Integration Services)
- Assist in building complementary reporting outside the financial system
- Assist in building business intelligence and analytics dashboards and visualization systems using MS Power BI, Preset/Superset or similar
- Work collaboratively, communicate and coordinate your team leader, and with key financial leadership and business stakeholders about aspects of the firm9s financial, business and accounting data
- Complete administrative and business tasks in a timely manner, including but not limited to timesheets, expense reports, and annual performance reviews
- Perform any other duties as assigned
QUALIFICATIONS:
- Bachelor9s degree
- Experience in developing enterprise level database and business/financial information technology systems
- Developer or DBA experience using a relational database system such Microsoft SQL Server Database, Oracle SQL Database, PostgreSQL, or MySQL
- Development or SQL coding experience on ETL integration systems, business processes, or financial reporting systems
- Experience coding in a language such as Python, R, C#
- Experience in 1 or more of the following:
- Exposure to Accounting or Financial systems, including Vendors and Vendor Invoicing, Expenses, Customers/Clients, Projects and Contracts, Customer Invoicing
- Experience in the full lifecycle of software development, such as Project Management, Business Requirements and Analysis, System Design/Architecture, Development including Coding, Quality Assurance/Testing, Deployment, and Production Support
- Experience building Business Intelligence, Analytics, Dashboards and Visualizations systems: including data sourcing, design and deployment. Use of BI tools such as MS Power BI, Tableau, Superset
If interested, qualified candidates should submit a resume and work samples or portfolio (no larger than 6 MB) through our careers website.
TVS offers a competitive salary and a comprehensive benefits package, including medical, dental, vision, life and disability insurance, as well as 401(k) Plan and ESOP program. TVS also offers resources and benefits to assist our employees with pursuit of professional licensure and certification.