Create databases and construct data sets to generate financial information. Construct key metric reports using large data sets to allow analytics and FP&A departments to access business processes and logistics in an efficient manner. Design, develop, and maintain multiple ad hoc queries with complicated financial reports and different types of drilldown reports. Analyze business processes to better design databases, data sets, and data dictionaries. Identify key data elements that must be subject to source data analysis capturing business rules as well as process rules relating to data. Engage in relational database modeling, dimensional data modeling, and data warehouse design. Work extensively with OLTP databases including Oracle and SQL/Server. Use programming language C/C++, HTML, SQL, SAS, Cognos and other sophisticated tools and languages.
Essential Functions:
· Build data dictionaries;
· Document existing processes, identifying gaps and providing remediation plans for the processes;
· Be involved in design, development, maintenance of multiple ad hoc queries;
· Identify data elements;
· Conduct testing for graphic applications;
· Identify data dependencies and data integration points and collect business metadata;
· Participate in analyzing business processes, relational database modeling, dimensional data modeling, and database design;
· Work extensively with SQL, SAS, and OLTP databases including Oracle and SQL/Server. Use Cognos reporting tool;
Education/Skills/Experience:
· Bachelors Degree in Finance or equivalent or 5+ years of related experience;
· Excellent written and verbal communication skills;
· Ability to work successfully in a team based environment;
· 4-6 years experience;
· Independent “thinker”;
*Local candidates only*
We recognize that confident people, with the right skills and proactive ideas, will enable us to continue our success. If you want to join our SquareTwo Financial team and you feel that you meet these requirements noted above, please submit your resume for our review.
* SquareTwo Financial is an Equal Opportunity Employer.
